Fix Microsoft Access Error 3046 in a Split Database
Question details
The user needs to resolve error 3046 when saving changes in a shared split Microsoft Access database.

- Product
- Microsoft Access for Microsoft 365
- Device & OS
- not provided
- Scenario
- Multiple users work with a split database whose front end, server, and workflow have not recently changed.
- Observed behavior
- Access displays “Could not save; currently locked by another user.”
Identify which users, forms, and records are affected, and note whether the error occurs when only one person is using the database. Ask the database administrator for the shared back-end location and access to its folder permissions.
Check record locks and use a local front end
Start here to identify conflicting edits and verify that users are not sharing one front-end file.
Ask all other users to close Access, then reopen the affected form and try saving the same record. Repeat with another user to see whether the error depends on concurrent access.
On each user's computer, check the file location in File > Info. Each user should open a separate local copy of the front end rather than a single shared front-end file.
In Access, open File > Options > Client Settings and review the record-locking options under Advanced. Compare the settings across front-end copies and consult the database administrator before changing them.
Ask the database maintainer to open the affected form in Design View and inspect its Record Locks property. A form-specific setting may influence how records are locked during editing.

Verify the shared back-end connection and permissions
Use this check if the error affects several users or persists when only one user is connected.
Check the back-end database for corruption
Consider database maintenance if locking and network checks do not explain the error.
Use WPS Office for Everyday Documents and Spreadsheets
WPS Office is a free, lightweight alternative for everyday office work, with a familiar interface and Microsoft Office format compatibility that helps you move documents and spreadsheets between suites. It does not fix Access error 3046 or replace a Microsoft Access database.

Frequently Asked Questions
Why does Access say another user has locked the record?
Another user may be editing the same record, or a form or database locking setting may be causing a conflict. Network, permission, or database issues can also contribute. Test the save with all other users disconnected first.
Should every user have a separate Access front end?
Yes. In a split database, each user should open a separate local front-end copy linked to the shared back end. Check the open file location under File > Info.
Can I delete the Access locking file?
Do not delete the .laccdb or .ldb file while anyone is connected. If it remains after everyone has closed the database, ask the administrator to investigate it in the back-end folder.
Where can I check record-locking settings?
Open File > Options > Client Settings and review the Advanced section. The database maintainer can also inspect a form's Record Locks property in Design View.




