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