Permission & Access Issues

Fix Microsoft Access Database Locking on a Shared Network

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Resolve locking errors when opening a Microsoft Access database stored on a shared network server.

Fix Microsoft Access Database Locking on a Shared Network
Product
Microsoft Access
Device & OS
not provided
Scenario
Multiple users need to open a shared Access back-end database over a network.
Observed behavior
Access reports “Could not lock file” or “File in use” when it cannot create or modify the database locking file.
Before you start

Identify the shared folder containing the back-end database and check whether it uses an .accdb or .mdb file. You may need a network administrator to review both share and folder permissions.

Solution 1Recommended

Check Shared-Folder Permissions and Database Open Mode

Use this solution when Access cannot create or update its locking file in the shared database folder.

1
Review folder permissions

Ask your network administrator to check both share and folder security permissions for every database user. Users need read, write, create, and delete access to the folder containing the back-end database.

2
Test folder access

In File Explorer, open the shared database folder using an affected user's account. Create a temporary text file, edit it, and delete it to check basic folder access.

3
Open the database in shared mode

In Access, go to File > Options > Client Settings and find the Advanced section. Set Default open mode to Shared, then close and reopen the database.

4
Check the locking file

Open the shared database and look in its folder for a corresponding .laccdb file for an .accdb database or an .ldb file for an .mdb database. If it cannot be created or modified, ask the administrator to check whether antivirus or network security software is blocking it.

5
Use local front-end copies

For a split database, give each user a local copy of the front-end file and open it from their computer, while keeping the linked back-end database in the shared folder.

Check Shared-Folder Permissions and Database Open Mode
Administrator access: Avoid routinely running Access as administrator. Fix the shared-folder permissions or security restrictions instead, unless support specifically directs otherwise.
Free Microsoft Office alternative

Use WPS Office for Shared Spreadsheet Work

WPS Office is a free, lightweight alternative for everyday document and spreadsheet work, with a familiar interface and Microsoft Office format compatibility to ease migration. It does not fix Access locking errors or replace an Access database application.

Use spreadsheets for suitable shared data tasks that do not require an Access databaseOpen and edit Microsoft Excel formats, including XLSXWork with a familiar, easy-to-use Office-style interfaceGet a lightweight office suite with free tools
QA img-9

Frequently Asked Questions

Why does Access need an .laccdb or .ldb file?

Access uses a locking file in the database folder to coordinate shared access. An .accdb database uses an .laccdb file, while an .mdb database uses an .ldb file.

What permissions do users need on the shared database folder?

Each user needs read, write, create, and delete permissions on the folder containing the back-end database. An administrator should check both network share and folder security permissions.

Where can I change the default Access open mode?

In Access, open File > Options > Client Settings, find the Advanced section, and set Default open mode to Shared. Close and reopen the database afterward.

Should everyone open the same front-end file from the network?

For a split database, each user should open a local front-end copy linked to the shared back-end database. This keeps users from sharing the same front-end file.