Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Access 2000 - Database Locked when opened by a specific computer.

01 Feb 2012   #1

Windows 10 Professional x64
Access 2000 - Database Locked when opened by a specific computer.

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?

My System SpecsSystem Spec
01 Feb 2012   #2


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.
My System SpecsSystem Spec
01 Feb 2012   #3

Windows 10 Professional x64

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.
My System SpecsSystem Spec


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

Thread Tools

Similar help and support threads
Thread Forum
database is locked?
This message popped up. Does any need to fix?
Browsers & Mail
Remote access to a specific computer on a LAN
Hi, The scenario is an office with multiple workstations, 1 ADSL fixed IP connection, domain member workstations peer-to-peer through a switch. The domain server is at a remote location. I want to RDP into a specific workstation. What I've been considering are the following - maybe/hopefully...
Network & Sharing
How can I mail merge with a locked Access DataBase?
Hi guys We have a help desk inquiry at the moment that I have no idea about. I have attempted several things over the last hour and cannot for the life of me get it working. Am I able to mail merge a letter in word with fields in a LOCKED Access DataBase? Your friend -Iroro
Microsoft Office
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
Specific website can't be opened, then firefox hangs at exit
Hi everyone I have just managed to get rid of one nasty virus, and then installed the Service Pack 1 on my Windows 7 pro 32 bit system. The scans are clean and everything is running back to normal now, except this: I cannot access my online banking website. When I try to, the page does not...
Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:41.
Twitter Facebook Google+