[AccessD] Array is locked

Just a wag, Rocky, but what if you ReDimmed the array element by element? It
might be that something somewhere in the middle is causing the problem. You
could easily find out whether the whole array is locked by just shrinking it
one element. If that works then try the loop and decrement the size until
she goes boom. Just a wag, as I said.

Arthur

On 3/17/08, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
>
> Lambert:
>
> Here's the Type:
>
> Private Type THRecord
>     TaskID As Long                  'T
>     StartDate As Date               'S
>     DueDate As Date                 'D
>     QuasiDueDate As Date            'Q
>     TargetDate As Date              'R
>     RequiredHours As Double         'H
>     EarliestCompleteDate As Date    'C
>     ASAP As Double                  'A
>     fOrdering As Boolean            'F
>     ErrorHours As Double            'E
>     TempReg As Double               'Z
>     DueDateFlag As Boolean          'FD
>     PastDueFlag As Boolean          'FP
>     ASAPFlag As Boolean             'FA
>     TargetDateFlag As Boolean       'FT
> End Type
> Dim mudTH() As THRecord             'TH
>
> There are lots of references to elements in the aray but at the point
> where
> the redim occurs, there are no references.  Does any reference lock the
> array and then the lock persists?  Is there a way to determine what
> element
> in an array is causing the lock or a way to release the array?
>
>
> TIA
>
> Rocky
>
>
>