Fix an Access Database Locked by the Admin User
Question details
The user needs to restore access to a split Microsoft Access database that reports an Admin user lock.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Multiple users access linked tables in a shared back-end database through a front end.
- Observed behavior
- Access reports that the Admin user has placed the database in a state that prevents it from being opened or locked.
Identify the shared back-end database and its folder, and ask all users to close their front ends and any direct connections to the back end. Have an administrator check for disconnected or lingering sessions before changing lock files or permissions.
Remove a Stale Access Lock File
Use this method when a lock file remains after every connection to the database has closed.
Ask everyone to close Access, and have the server administrator check for open database files or lingering network sessions.
Open the folder containing the back-end database and look for a file with the same base name and an .laccdb or .ldb extension.
If no users or processes are connected and the lock file remains, delete the .laccdb or .ldb file. Do not delete the database file.
Open a user's front end and test a linked table. Then have another user connect to verify shared access.

Check Shared-Folder Permissions and Front-End Copies
Use this approach if the lock returns or users cannot create, update, or delete the lock file.
Compact and Repair a Copy of the Back-End Database
Try this if the lock and permissions checks do not resolve the issue and database corruption is suspected.
Use WPS Office for Everyday Spreadsheet and Document Work
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and spreadsheets. Its format compatibility helps you move common files between office suites. It does not fix Access locks or replace an Access database.

Frequently Asked Questions
Does the Admin user message mean an administrator deliberately locked the database?
Not necessarily. The message can appear when a connection or lock file prevents access. Check for active or lingering sessions before deleting any lock file.
Can I delete an .laccdb or .ldb file while someone is using the database?
No. Access uses the lock file during shared access. Delete it only if it remains after all users and processes have disconnected.
Which folder permissions do Access users need?
Users generally need permission to read, write, create, and delete files in the shared back-end folder. An administrator should check both share permissions and the folder's Security permissions.
Why should each user have a separate front end?
A local front end avoids having multiple users share the same front-end file. Each copy can still use linked tables that point to the same shared back end.
Can WPS Office unlock an Access database?
No. The lock must be resolved in Access or through the shared-folder and server settings. WPS Office can work with spreadsheet data exported from Access, but it does not replace the Access database.




