Permission & Access Issues

Fix Microsoft Access Database Opening Exclusively on Windows Server

Algirdas JasaitisAlgirdas Jasaitis Oct 9, 2026 868 views

Question details

Users are encountering a 'file already in use' error when attempting to connect multiple front-end clients to a shared back-end Access database on a Windows Server.

How to Fix Microsoft Access Database Opening Exclusively on Windows Server
Product
Microsoft Access
Device & OS
Windows Server
Scenario
Multiple users are attempting to connect their separate front-end databases to a single shared back-end database over a network.
Observed behavior
The database opens in exclusive mode for the first user, preventing concurrent users from accessing the shared data and generating a 'file already in use' error message.
Before you start

Verify that you have administrative access to the Windows Server folder hosting the back-end database, and ensure all users have fully closed Access before making structural or permission changes.

Solution 1Recommended

Distribute Separate Local Front-End Copies to Each User

The most common cause of this locking error is multiple users launching the exact same network-hosted front-end file instead of local copies.

In a split Access database environment, the back-end (tables and data) resides on the server, while the front-end (forms, queries, reports) must be distributed to each individual user's machine.

1
Create the master front end

Build your front-end .accdb file and use the Linked Table Manager to connect it to the shared back-end file located on the Windows Server.

2
Distribute local copies

Copy the master front-end file and paste it directly onto the local desktop or documents folder of every individual user.

3
Verify connections

Open the local front-end copy on a user's machine, navigate to 'External Data', click 'Linked Table Manager', and confirm the paths point to the shared network back-end rather than a local drive.

Distribute Separate Local Front-End Copies to Each User
Best Practice: Never allow users to open the same physical front-end file simultaneously over the network, as this will inevitably cause corruption and exclusive locking issues.
Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While WPS Office does not include a direct database management application like Microsoft Access, it offers a highly compatible, lightweight, and free alternative for Word, Excel, and PowerPoint files. If you are struggling with complex Microsoft Office licensing or network locking issues on shared documents, WPS Office provides excellent cloud collaboration tools and seamless file sharing.

  1. 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the software: Run the downloaded installer file and follow the on-screen instructions to complete the setup.
  3. 3. Open your files: Launch WPS Office to immediately start opening, editing, and sharing your Word, Excel, and PowerPoint documents without locking issues.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Built-in cloud collaboration features to avoid 'file already in use' locking errors.Free and lightweight suite for daily document, spreadsheet, and presentation tasks.Familiar, tabbed user interface for easy migration.
QA img-9

Frequently Asked Questions

Why does Microsoft Access say the database is already in use?

This error typically occurs when another user has opened the database in 'Exclusive Mode', multiple users are running the exact same front-end file instead of their own local copies, or users lack the necessary network folder permissions to create the .laccdb lock file.

How do I change the default open mode to Shared in Access?

Launch Microsoft Access, navigate to File > Options > Client Settings. Scroll down to the 'Advanced' section. Under 'Default open mode', select the 'Shared' radio button instead of 'Exclusive', and click OK.

What is the purpose of the Access lock file (.laccdb)?

The .laccdb file (or .ldb in older versions) tracks which users are currently accessing the database and which records they are editing. It is created automatically when the first user opens the database and deletes itself when the last user exits. If folder permissions prevent its creation, the database will fail to open in shared mode.

Can multiple users edit an Access database at the same time?

Yes, but the database must be split into a back-end (containing tables) stored on a shared network drive, and multiple local front-ends (containing queries and forms) distributed to each user's computer. The database must also be set to Shared open mode.