Others

Fix Microsoft Access Database Open by Another User When Saving As

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

The user needs to save an Access database under a different file name but receives a message that it is open on another computer.

Fix Microsoft Access Database Open by Another User When Saving As
Product
Microsoft Access
Device & OS
not provided
Scenario
Saving an ACCDB database with a different file name, potentially while it is shared with other users.
Observed behavior
Access reports that the database is already open by another user or on another computer.
Before you start

Identify the ACCDB file's location and ask anyone who may be using it to close the database. Confirm whether users open the same file or use separate local front ends linked to a shared back end.

Solution 1Recommended

Clear active connections and retry Save As

Use this approach when another user, an Access process, or a leftover lock file may be preventing the save.

1
Close the database everywhere

Ask all users to close the affected database and exit Microsoft Access on their computers.

2
Check for remaining processes

On each relevant Windows computer, open Task Manager and look for Microsoft Access processes. End a remaining process only after confirming that its database work is closed.

3
Inspect the lock file

Open the folder containing the ACCDB file in File Explorer and look for a matching .laccdb file. If all users and Access processes are closed but the lock file remains, delete it.

4
Retry Save As

Reopen the database in Access and select File > Save As > Save Database As. Choose a new file name and location.

Clear active connections and retry Save As
Do not remove an active lock file: An .laccdb file can be present while the database is in use. Do not delete it until you have confirmed that every connection is closed.
Free Microsoft Office alternative

Use WPS Office for Everyday Documents and Spreadsheets

WPS Office is a free, lightweight alternative for documents and spreadsheets, with a familiar interface and Microsoft Office format support to make migration easier. It does not replace Microsoft Access or resolve ACCDB database locks.

Work with spreadsheets when a full Access database is not requiredOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for common office tasksInstall a lightweight office suite for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access say the database is open when nobody is using it?

An Access process may still be running, or a lock file may remain after an abnormal shutdown. Check Task Manager on the relevant computers and inspect the database folder for a matching .laccdb file.

Can I delete the Access lock file?

Delete a leftover .laccdb file only after confirming that all users have closed the database and no Access processes are still connected. Do not delete it while the database is in use.

Does Save As make an Access database suitable for multiple users?

No. File > Save As creates another file but does not automatically create a shared back end and separate local front ends. Use Database Tools > Access Database to split an appropriate database.

Where should each user keep the front-end database?

Give each user a separate front-end ACCDB copy on their computer. Use Linked Table Manager to check that its tables point to the shared back-end database.