Background

Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals. 

Problem

When I run Total Access Analyzer 2000 I receive Error 3734. 

Solution

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.

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
• PDF Fact Sheet