>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