How To Unlock Or Remove Access Database LDB or LACCDB File

Summary:

This blog emphasizes on detailed information regarding Access database .ldb and .laccdb file. Moreover, it covers ways to open ldb file, how to delete ldb/laccdb file of MS Access.

Being an Access database user, you are probably familiar with Microsoft Access lock files (ldb or laccdb). You must have noticed that when you open up any Access database it automatically creates another file with same name but with locking file extensions like LACCDB or LDB.

 But the problem with this Microsoft Access Lock File is that the ldb or laccdb file doesn’t delete by itself. Thus, as a result of which your database continues to display as locked.

Practical Scenario:

I’ve just added Access Security to an existing database and have signed-on and off as various users during the day. 

However, the LDB file still thinks I have the database open for exclusive use even though I’m not currently using it.  Consequently, I can’t delete or replace the database, or open it for exclusive use.

How can I clear or delete the LDB file?

source:

https://www.experts-exchange.com/questions/10234953/Access-Security-How-to-reset-clear-delete-an-LDB-file.html

Access Record-Locking File

Access Record Locking File

Every Access database version uses a lock file which prevents users from making modification on same record simultaneously. This Access lock file doesn’t contain any data and can be deleted by itself when the database is gets closed. In some cases, this file doesn’t delete by itself. When you try to attempt such delete procedure you may encounter issue like “cannot delete Access record locking file”. and further your database continues to appears locked.

In newer Access database version, the default Access file extension is accdb. it’s lock file share the same name and location same as main access database file but having extension LACCDB.  But the older Access database version like 2002/2003, these extensions are MDB and LDB.

It’s very rare that, this Access database locking file doesn’t gets deleted by itself and so as you need to remove it manually.  Suppose, you know the name of that database but don’t know where it gets saved then you have the two options:

  • Perform search operation to find all files with the LACCDB extension.
  • Contact your network administrators and allow all necessary information.

What’s The Purpose Of This Lock File?

MS Access lock file helps to keep track of one or more users who all are currently working on same Access database. Therefore, it plays a great role in keeping detail log of multiple users with machine and user name. At first, it’s a safe and harmless file that executes along with the opened Access database file in same location.

Well you can see this file in plain text editor using some editors that might return odd characters. So, make use of the MS Word instead of notepad and you will see machine and user name listed for members that are currently using the Access database file.

When last users using the Access database closes down the shared Access database, it will automatically remove Access database lock file.  but sometime it won’t deleted itself and you need to delete it manually. So, that you can use your Access database without any restriction.

Why You Can’t Delete Access Record Locking File?

 

Why You Can’t Delete Access Record Locking File

Whenever the last user of your Access database closes the database, the respective ldb/accdb file is gets deleted. But the problem arises when a user don’t have such rights to delete such lock file or when the access database is get corrupted somehow. In that case, you cannot delete Access record locking file.

As, the ldb/accdb file contains information about the user using who uses the database at the time it was marked as corrupted.  That’s the reason why it won’t get deleted even when you attempt to do so.

What Issue Encountered Due To This Ldb/Laccdb File?

MS Access jet database engine mainly uses this lock file information to obstruct users from writing data to pages or records which other users have locked. And also, for knowing which pages and records are been locked. If Jet database engine fetches a lock conflict with any other user then it reads .ldb file to get the system and security name of user who are having such file/record locked.

Meanwhile this lock conflict situation, users encounters “Write conflict” pop-up message which allows you for saving the records, copy it to the Clipboard, or drop the modification that you done.

In some cases, users receive the following error message:

Couldn’t lock table <table name>; currently in use by user <security name> on computer <computer name>.

If the .ldb file is get corrupted, then you may see scrambled text instead of user names in the above shown lock conflict error message.

Note:

By using the visual basic application in Access 2002 or later, you can easily see the list of users that are logged in into any specific database.

What Are The Reasons Behind Inaccessibility Of  .Ldb File?

Reasons Behind Inaccessibility Of  .Ldb File

Inability to open and Access ldb file doesn’t mean always means that you have improper or inappropriate software installation. Other reason behind the inaccessibility of your MS Access Record-Locking Information Format file are as follows. So, just check it out.

  • LDB file corruption that is being opened.
  • Inappropriate links to the LDB file present in registry entries.
  • From the Windows registry Unintentional deletion of LDB description.
  • Improper installation of applications which supports the LDB file format.
  • May be the LDB file which you are trying to open is get infected with some undesirable malware.
  • Your PC don’t have enough hardware equipment to support with right opening of MS Access LDB file.
  • Drivers used by your PC to open up the LDB file are now outdated.

If you are so sure that all the above-mentioned reasons doesn’t persist in your case, then LDB should work fine with your program without rendering any issue. in that case, go down to our next section.

How To Unlock Access ldb/laccdb File?

How To Unlock Access ldb/laccdb File

To know how to perform Access database lock file unlocking task or how to open the .ldb file try out the following option:

Method 1:

Well the most common reason behind unable to open LDB File is lack of appropriate applications installed in your PC. In such case, you need to find, download and install applications which perfectly supports the LDB file format.

Method 2:

If you can’t delete the Access “lock file”. and your PC frequently showing that there are some users connected to the database but in reality, there is no such user connected right now.

Then in that case, try opening the .ldb file using notepad. As this will show both the thing: one who all are currently using the database and second workstations which were in the Access database.

When any user exit or closes their workstation their name and Access login id, admin; are left in a slot present in the LDB file.  Well this slot gets overwritten with the new information when next time someone open the MDB/ACCDB file.

How To Perform Access Database Lock File Removal Task?

How To Perform Access Database Lock File Removal Task

Check Out The Folder Privileges Option:

If you are sharing up your database, the mdb or accdb file must needs to be located in folder where user has the privilege of create, read, write and delete. If you want to assign different file privileges like read-only or read-write etc. Then also it’s compulsory to have create, read, write and delete permissions to the folder having mdb/accdb file.

NOTE:

If any user opens their Access database in exclusive mode then record locking is not applied. Thus, Microsoft Access doesn’t attempt to open or create any .ldb file.  If always the access database is opened for Exclusive use then user needs to have only read/write privilege to that folder.

How To Fix Access Database File Corruption Issue?

Repair Corrupt/Damaged/Lost MS Access Database Files

If even after trying the above solution for Access Database Lock File Removal if unfortunately, you are unable to use your Access database. Then the chances are high that your database is get corrupted or damaged.

Don’t worry you can fix this issue by using MS Access Repair & Recovery tool. It is professional software for fixing your corrupt, damaged or inaccessible Access database. It can easily restore your corrupt tables, indexes, queries and relations. You can also recover the password protected forms or modules and many more.

Conclusion:

After reading the complete post, hopefully you have got all answer of your queries regarding Access database ldb/laccdb file. So, try all the aforementioned fixes to open ldb file or to remove Access database Lock File.  if in case you encounter any similar Access database lock issue or any other access database problems then you can ask in our comment or FAQ section.

FURTHER READING:

3 Easy Fixes To Resolve MS Access 3052 :“File Sharing Lock Count Exceeded” Error

How To Resolve “Access Form Not Updating Table” Issue In Access 2010/ 2013/2016 database?

How To Unlock MS Access .mdb or .accdb Database

How To Resolve Microsoft Access Record Locking Issue During Multi-User Access?

How To Unlock Or Remove Access Database LDB/LACCDB File