Fix Microsoft Access Database Open by Another User When Saving As
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.

- 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.
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.
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.
Ask all users to close the affected database and exit Microsoft Access on their computers.
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.
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.
Reopen the database in Access and select File > Save As > Save Database As. Choose a new file name and location.

Split a shared Access database into front-end and back-end files
Use a split design if multiple people currently work in the same ACCDB application file.
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.

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.




