1. Eric R. **

This is great! But, how would I release all schema locks

programmatically, using VBA? | Is there a method such as schemaLock.ReleaseAll?

Thanks, –Eric


2. geographika **

As any application accessing the database would itself cause a lock on

the .mdb file, I don’t think it would be possible with VBA code. | You can use code from to find a list of users connected to the database and if they are in a suspect state. | Failing all else you could write code to delete the .ldb file, but this may cause more problems than it solves.

Add Comment