Permission & Access Issues

Fix Microsoft Access Cannot Save Database on Shared Drive

WPS Editor Oct 9, 2026 871 views

Question details

A user is unable to create or open a Microsoft Access database saved on a shared company drive because Access reports the file is locked by another user, despite the user having appropriate folder permissions.

How to Fix Microsoft Access "Locked by Another User" Error on a Shared Drive

Product: Microsoft Access
Device & OS: not provided
Scenario: Attempting to access, create, or save a multi-user database file located on a company network shared folder.
Observed behavior: Microsoft Access displays a file lock error indicating another user has the database open, blocking the current user from modifying or saving changes, even though general network folder permissions are granted.

Before you start

Verify your network drive permissions by trying to create, edit, and delete a simple text or Word document in the same shared folder to rule out general OS-level read/write restrictions.

Solution 1Recommended

Add the Shared Folder as a Trusted Location

Network drives are often blocked by Microsoft Office security policies. Adding the network folder to Trusted Locations allows Access to fully interact with the files and lock mechanisms.

Microsoft Office places strict security restrictions on files opened from network locations. If Access cannot verify the security of the shared folder, it may fail to create the temporary lock file (.laccdb) needed for multi-user access, resulting in a false 'locked by another user' error.

Open Access Options

Launch Microsoft Access, click on the 'File' tab in the top-left corner, and select 'Options' from the bottom of the menu.

Navigate to Trust Center

In the Access Options dialog box, click on 'Trust Center' in the left-hand pane, then click the 'Trust Center Settings' button.

Enable Network Trusted Locations

Select 'Trusted Locations' from the left menu. At the bottom of this window, check the box that says 'Allow Trusted Locations on my network (not recommended)'.

Add the Shared Drive Path

Click 'Add new location', browse to the specific shared drive path containing your database, check 'Subfolders of this location are also trusted' if necessary, and click 'OK'.

Add the Shared Folder as a Trusted Location

Changes Applied: You may need to restart Microsoft Access for the new Trust Center settings to take full effect.

Solution 2

Split the Database for Multi-User Environments

If multiple users are opening the exact same single database file simultaneously, lock errors will naturally occur. Splitting the database prevents data locking by separating the interface from the tables.

Free Microsoft Office alternative

Discover a Lightweight and Cost-Effective Office Suite

While Microsoft Access is a specialized tool within the MS Office suite for database management, you can handle your daily document, spreadsheet, and presentation tasks seamlessly with WPS Office. It provides robust compatibility without the heavy resource usage or subscription costs of traditional Office setups.

1. Download WPS Office: Visit the official WPS website and download the free, lightweight installation package tailored for your operating system.
2. Install the Suite: Run the installer. The process takes just a few minutes and requires minimal system resources.
3. Open Your Existing Files: Launch WPS Office and directly open your existing Microsoft Office documents, spreadsheets, and presentations to start working immediately.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation that runs incredibly fast on Windows, Mac, and Linux devices.Familiar tabbed user interface ensuring a zero-learning-curve migration for Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Access say my database is locked by another user when no one is using it?

This often happens if Microsoft Access lacks the proper security permissions to create or delete the temporary lock file (.laccdb) in the shared folder, or if the folder is blocked by the Office Trust Center. Adding the folder to Trusted Locations usually resolves this.

How do I know if the issue is with Access or my network drive permissions?

You can isolate the issue by attempting to create and delete a different file type, like a simple text document or a Word file, inside the same shared folder. If you can modify other files perfectly fine, the folder permissions are correct and the issue is specific to Access settings.

What is the difference between a front-end and back-end Access database?

The back-end database contains only the raw data tables and is meant to be stored on a shared network drive. The front-end database contains the user interface components (queries, forms, reports) and should be saved locally on each individual user's computer to prevent network file-locking conflicts.

Document & File Issues