Access Database Crash

Posted on 2009-04-21
Medium Priority
Last Modified: 2012-05-06
I have an access database that is locked open because the system crashed How do I force it closed
Question by:CRAITS
LVL 15

Expert Comment

ID: 24198036
1) Verify that the database is not actually open on another machine
2) Delete the associated LDB file for that database

Make sure you get the LDB file not the MDB File
If someone else has the file actually open you will not be able to delte the LDB file
LVL 58

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 24198129
Note that you may not be able to delete the .LDB file even if no one is currently in there as the OS may still be holding a lock on the file.
If that's the case, the simplest thing is to reboot the machine.  If that can't be done, then you'll need to clear the lock manually.  See the following thread:
For the procedures to remove the file handle and the lock.
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 24198227
This is a great little free tool that will kill LDB's in some, but not all ... cases.  Easy to try ... and VERY handy for other apps, usb drives that won't eject, etc.



Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question