File Sharing Problems

How to Fix Microsoft Access Database Already in Use on Network Share

Jason MillerJason Miller Nov 4, 2026 869 views

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.

How to Fix Microsoft Access Database Already in Use on Network Share
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.
Before you start

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.

Solution 1Recommended

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.

1
Identify the direct UNC path

Find the true server name and shared folder path instead of using the mapped drive letter or DFS namespace (e.g., use \\ServerName\SharedFolder).

2
Update database shortcuts

Right-click your Microsoft Access database shortcut, select Properties, and change the Target to point to the direct UNC path.

3
Test the connection

Double-click the updated shortcut to open the database and verify if the 'already in use' error is resolved.

Bypass DFS Path and Connect Directly to the File Server
Network Deployment: If the direct path works, investigate your network's DFS configuration or Group Policy drive mappings before deploying the database again to multiple users.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to complete the setup in minutes.
  3. 3. Open your files: Launch WPS Office and directly open your existing Microsoft Office documents without worrying about formatting loss.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight installation with faster load times and fewer background network conflictsFamiliar user interface requiring zero learning curve for seamless migrationFree to use with powerful built-in PDF editing and conversion tools
microsoft office alternative - wps office

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.