Solved Access 2000 - Database Locked when opened by a specific computer.

[askavatar]

Hi again, everyone. I'm having some Access woes with which I have been unable to find help about around the web, as my circumstances don't seem to fit other reports of this problem. I get the dreaded:
The database has been placd in a state by user <name> on machine <name> that prevents it from being opened or locked.


Here's the kicker, its used actively by 2 users, when user 1 opens it, user 2 gets that error (or any other person that tries to get into the database), if user 2 opens it first (or any other user) then any and all users that open it up can use it without any problems.

Now, I don't have any plugins in use, no VB code getting data from other sources, or mail merges, or anything like that, everything in this database is internal. What I can't figure out is ONLY user 1's computer will lock the database and ONLY when she's the first to open it.

Any Ideas?
Avatar

 

[bbinnard]

See if there is a left-over <name>.ldb file in the same directory as the <name>.mdb file. the LDB file (Lock Data Base) is where Access keeps track of who has the file open, which record is being accessed, etc. The LDB file is supposed to get deleted with the database is closed, but if there is a crash or something weird then LDB file can get left behind.

If you find an LDB file just delete it and try again.

 

[askavatar]

Well, I just got done writing a front end for it, and creating a duplicating program that I ran across over on the dbforums.

To answer your question bbinnard, there were no errant LDBs, this has been an ongoing thing with this database. I just thought it was strange that it was always the same computer having the problem. Making up the frontend didn't take as long as I thought it would.