Running Total Access Analyzer 2000:
- Error 3734, "The database has been placed in a state by user '<name>' on machine '<name>' that prevents it from being opened or locked
After closing your database, see if there's an Access lock file (*.LDB) on the database (for instance, if it's Northwind.mdb, the lock file would be Northwind.ldb). This would indicate another user has the database open. This could be caused by a few reasons:
Another user currently has the database opened
You have another instance of Access opened on that database
A non-Access program (maybe a VB6 or .NET program) has the database open
Once you get the other user(s) out of your database, Total Access Analyzer will be able to document it. If you cannot get exclusive rights to the database, make a copy of the database and document that.
If you want to monitor and see who's currently in your database at any time, get our Total Access Admin program.