Permission & Access Issues

Fix Microsoft Access Error 3046 in a Split Database

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

The user needs to resolve error 3046 when saving changes in a shared split Microsoft Access database.

Fix Microsoft Access Error 3046 in a Split 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.”
Before you start

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.

Solution 1Recommended

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.

1
Test with one user

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.

2
Check front-end copies

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.

3
Review locking settings

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.

4
Check the affected form

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.

Check record locks and use a local front end
Coordinate edits: If the error occurs only when users edit the same record, coordinate those edits while the database maintainer reviews the locking configuration.
Free Microsoft Office alternative

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.

Work with Microsoft Excel XLSX spreadsheets and Word DOCX documentsUse a familiar interface for common document and spreadsheet tasksOpen and edit spreadsheet data exported from AccessUse a free, lightweight suite for everyday office work
microsoft office alternative - wps office

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.