locked
How to remove a database lock file (_be.laccdb)? RRS feed

  • Question

  • How can I remove a database lock file so that I can recover a _be.accdb file?

    When I try to remove the .laccdb file it says it is open in another program and wont let me delete it?

    Thanks


    Nath

    Monday, March 27, 2017 10:39 AM

Answers

  • Normally this indicates someone is currently using the database so you can't do anything until they log out.

    The other possibility is that you have a hidden msaccess.exe process with an active lock on the file.  If  that is the case you need to open the task manager, kill the orphan process and then manually delete the lock file.  If this is the case, then you need to figure out why you are getting orphan processes like this because they can create real headaches and corruption.


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Monday, March 27, 2017 12:41 PM
  • Hi NaPazz,

    Whenever the last user closes a shared database, the .laccdb file is deleted. The only exceptions are when a user does not have delete rights or when the database is marked as corrupted. Then, the .laccdb file is not deleted because it contains information about who was using the database at the time the database was marked as corrupted.

    please try to refer the suggestion given by JohnBlanch in thread below may help you to solve your issue.

    Access Database Clear Lock Files

    for more information , you can visit links below.

    Introduction to .ldb files

    You may receive a "file already in use" error message when you try to open an Access database that is located on a server

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Tuesday, March 28, 2017 1:36 AM
  • Open the Computer Management in Windows on the system hosting Access database file, Now GOTO

    System Tools --> Shared Folders --> Open Files

    and there you may see if the .accdb and .laccdb files are listed. If so, close them by right-clicking or by choosing Close Open File in More Actions.

    This work in my case and I was able to delete .laccdb file.

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Tuesday, March 28, 2017 4:01 AM
  • Process Explorer is another handy utility for identifying which processes have a file open:

    https://technet.microsoft.com/en-us/sysinternals/processexplorer.aspx


    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Tuesday, March 28, 2017 12:07 PM

All replies

  • Normally this indicates someone is currently using the database so you can't do anything until they log out.

    The other possibility is that you have a hidden msaccess.exe process with an active lock on the file.  If  that is the case you need to open the task manager, kill the orphan process and then manually delete the lock file.  If this is the case, then you need to figure out why you are getting orphan processes like this because they can create real headaches and corruption.


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Monday, March 27, 2017 12:41 PM
  • Hi NaPazz,

    Whenever the last user closes a shared database, the .laccdb file is deleted. The only exceptions are when a user does not have delete rights or when the database is marked as corrupted. Then, the .laccdb file is not deleted because it contains information about who was using the database at the time the database was marked as corrupted.

    please try to refer the suggestion given by JohnBlanch in thread below may help you to solve your issue.

    Access Database Clear Lock Files

    for more information , you can visit links below.

    Introduction to .ldb files

    You may receive a "file already in use" error message when you try to open an Access database that is located on a server

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Tuesday, March 28, 2017 1:36 AM
  • Process Explorer is another handy utility for identifying which processes have a file open:

    https://technet.microsoft.com/en-us/sysinternals/processexplorer.aspx


    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by NaPazz Tuesday, March 28, 2017 12:39 PM
    Tuesday, March 28, 2017 12:07 PM