Does anbody know how to free locks on a database using ADO
I know in DAO you can use the DBEngine.idle method but this appears not to work as the I can't release the lock on the database. It claims I still have a connection to it.
AAARRRRRGGHHHHHH!!
Printable View
Does anbody know how to free locks on a database using ADO
I know in DAO you can use the DBEngine.idle method but this appears not to work as the I can't release the lock on the database. It claims I still have a connection to it.
AAARRRRRGGHHHHHH!!
He Hehh
I found that if I use the following it works
Code:
DBEngine.Idle dbFreeLocks
DBEngine.Idle dbRefreshCache
I would consentrate on what is causing the lock in the first place. You should look at what type of connection and the type of locking you have on your recordset (if it is a recordset you have the lock problem with).
Regards,
Chris