Access Database Crash

Posted on 2009-04-21
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

    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 56

    Accepted Solution

    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 - Access MVP)
    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now