How to Fix Microsoft Access Database Already in Use on Network Share
Question details
Users encounter a 'file is already in use' error when trying to open a Microsoft Access database hosted on a network share, even with correct file permissions.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Opening a shared ACCDB file over a network share, DFS path, or mapped drive in a multi-user environment.
- Observed behavior
- Access incorrectly reports the database file is already in use and locks the user out, despite correct network permissions and no other users actively modifying the file.
Ensure all other users have completely closed the Access database before troubleshooting, and verify that you have full read, write, and delete permissions for the network folder containing the ACCDB file.
Bypass DFS Path and Connect Directly to the File Server
DFS paths, SUBST drives, or mapped network drives can cause locking conflicts. Connecting directly to the server's UNC path often bypasses the issue.
Network configurations such as Distributed File System (DFS) paths can sometimes mismanage file locking mechanisms required by Microsoft Access. By bypassing these logical paths and connecting directly to the physical server path, you can eliminate the routing layers that cause the lock error.
Find the true server name and shared folder path instead of using the mapped drive letter or DFS namespace (e.g., use \\ServerName\SharedFolder).
Right-click your Microsoft Access database shortcut, select Properties, and change the Target to point to the direct UNC path.
Double-click the updated shortcut to open the database and verify if the 'already in use' error is resolved.

Verify Lock File Creation and Deletion Permissions
Access needs permission to create, modify, and delete the lock file (.laccdb) to manage multi-user access correctly.
Roll Back to a Previous Stable Office Build
Recent Office updates can sometimes introduce bugs related to network drive configurations and file locking.
Looking for a Lightweight and Free Alternative to Microsoft Office?
Network locking issues and update bugs frequently disrupt Microsoft Office workflows. If you need a reliable suite for your documents, spreadsheets, and presentations, consider switching to WPS Office. It provides a highly compatible, free, and lightweight productivity solution.
- 1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to complete the setup in minutes.
- 3. Open your files: Launch WPS Office and directly open your existing Microsoft Office documents without worrying about formatting loss.

Frequently Asked Questions
Why does Access say my database is in use when it's not?
This happens when a lock file (.laccdb) fails to delete after the last user closes the database. It can also occur if a network synchronization delay or backup software holds the file handle open on the server.
What is a Microsoft Access lock file?
A lock file (.laccdb for newer databases, .ldb for older ones) is a temporary file automatically created in the same folder as your database. It tracks which users have the database open to prevent conflicting data edits.
How can I force a network server to release an Access database?
An IT administrator can go to Computer Management on the file server, navigate to System Tools > Shared Folders > Open Files, and forcefully close the open file handle for the affected Access database.
Does splitting the Access database fix the 'already in use' error?
Yes, splitting the database into a back-end (tables on the network) and a front-end (forms/queries on each user's local PC) significantly reduces network lock conflicts and improves overall database performance.




