Cool! Glad it worked! =)

~~Bonnie


>>Probably all you need to do is to just make sure you close your connection in your catch:
>>

>>            Catch loError As Exception
>>                oApp.cError = oApp.ErrorSetup(loError, oApp.Debug(cSQL))
>>                oConnection.Close()
>>            End Try
>>

>
>Wow! That did it.
>
>I have found that this got locked for a few minutes and went away by itself. So, once an error occured, the lock was persisting for a few minutes. Now, with this adjustment, it never happens. Thanks