What Is a .ldb File? (Access Lock File That Will Not Delete)

What Is a .ldb File?

Microsoft Access left a .ldb file next to your .mdb database and it will not delete. It is just a lock file. Here is what it does and how to clear a stale one safely.

Filename or extension

Category

Safe to delete?

Opens with

What a .ldb file is

A .ldb file is the record-locking file that Microsoft Access (2003 and earlier) creates the moment an .mdb database is opened. It takes the same name as the database and sits in the same folder — open Sales.mdb and Access writes Sales.ldb beside it. Newer Access versions use the .laccdb extension for the .accdb format, but the job is identical.

Why it exists

The lock file tracks who currently has the database open, so two people on a shared .mdb cannot overwrite the same record at the same time. It records each user's computer name and Access security name. When the last user closes the database, Access deletes the .ldb automatically.

Why it will not delete

If the .ldb stays behind when nobody is in the database, Access did not shut down cleanly — usually a crash, a force-quit, or a hidden MSACCESS.EXE process still holding the lock. On a network share, another user or a sync/backup client may still have it open, which also recreates it the instant you delete it.

Is it safe to delete?

Yes — once the database is closed everywhere. The .ldb holds none of your table data; it only lists the current users. Deleting an orphaned lock does not harm the .mdb. The next time someone opens the database, Access builds a fresh lock file.

How to clear a stuck .ldb

1. Make sure every user has closed the database. 2. Open Task Manager and end any lingering MSACCESS.EXE process. 3. Delete the .ldb file. 4. If it still refuses to delete, a reboot releases the ghost lock, then delete it. 5. If it reappears immediately, a user or a OneDrive/Dropbox sync client still has the folder open.

If the database is marked corrupt

Occasionally Access flags the .mdb as suspect and the lock will not clear. Make a copy of the .mdb, then use Compact and Repair Database (Tools → Database Utilities) on the copy to reset the locking state.

FAQ

What is a .ldb file?

It is the record-locking file older Microsoft Access versions create next to an .mdb database while it is open, listing who has it open so users cannot overwrite the same record.

What is the difference between .ldb and .laccdb?

They do the same job. .ldb is the lock file for the old .mdb format (Access 2003 and earlier); .laccdb is the lock file for the newer .accdb format.

Is it safe to delete a .ldb file?

Yes, once the database is closed everywhere. It holds no table data, so deleting an orphaned lock does not harm your .mdb.

Why can't I delete the .ldb file?

Because something still has the database open: a user on a share, a hidden MSACCESS.EXE process, or a sync client holding the folder. Close all of them, or reboot, then delete it.

Why does the .ldb file keep coming back after I delete it?

Another user is opening the database, or a OneDrive/Dropbox client is syncing the folder and reopening it. Access recreates the lock whenever the database is opened.

Does deleting the .ldb file lose any data?

No. The lock file only lists current users; all your tables and data live in the .mdb. A fresh lock file is created next time the database opens.