Fix Microsoft Access Database Opening Exclusively on Windows Server
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.

- 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.
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.
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.
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.
Copy the master front-end file and paste it directly onto the local desktop or documents folder of every individual user.
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.

Configure Folder Permissions for the Locking File (.laccdb)
Access requires specific network folder permissions to create and delete the lock file that manages concurrent users.
Force Quit Hidden Processes and Set to Shared Mode
A hidden instance of Microsoft Access running in the background can hold the database open in exclusive mode.
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. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the software: Run the downloaded installer file and follow the on-screen instructions to complete the setup.
- 3. Open your files: Launch WPS Office to immediately start opening, editing, and sharing your Word, Excel, and PowerPoint documents without locking issues.

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.




