Others

Fix Microsoft Access Record Locking and Back-End Connection Error

John WilsonJohn Wilson Nov 2, 2026 869 views

Question details

Users experience record locking and a loss of connection between the front-end and back-end in a split Microsoft Access 2019 database.

Fix Microsoft Access Record Locking and Back-End Connection Error
Product
Microsoft Access 2019
Device & OS
not provided
Scenario
Using a split front-end and back-end Access database with an ADODB recordset and optimistic locking.
Observed behavior
Records become locked after approximately one minute of use, causing the front-end application to lose its connection to the back-end database.
Before you start

Verify that your network connection is stable and ensure you have full read/write permissions to the shared network folder hosting the back-end database file.

Solution 1Recommended

Place Database Files in a Trusted Location

Adding the folders containing both your front-end and back-end database files to Microsoft Access's Trusted Locations can resolve unintended locking and connection drops.

Microsoft Access implements strict security protocols that may interfere with ADODB recordsets if the files are not recognized as safe. Designating the folder as a Trusted Location bypasses these restrictions.

1
Open Access Options

Launch Microsoft Access, click on the 'File' tab in the top left corner, and select 'Options' located at the bottom of the navigation pane.

2
Navigate to Trust Center

In the Access Options dialog box, click on 'Trust Center' in the left sidebar, and then click the 'Trust Center Settings' button on the right.

3
Add Trusted Location

Select 'Trusted Locations' from the left menu and click 'Add new location'. Browse to the folder containing your back-end database, check the box for 'Subfolders of this location are also trusted', and click 'OK'.

Place Database Files in a Trusted Location
Tip: Repeat these steps to add the folder containing your front-end application file to the Trusted Locations list as well.
Free Microsoft Office alternative

Looking for a Lightweight Alternative for Word, Excel, and PowerPoint?

While WPS Office does not include a database management tool like Access, it is an exceptional, free alternative for your daily document, spreadsheet, and presentation needs. If you are frustrated by heavy software bugs or connection issues, try WPS Office for a fast, reliable, and lightweight experience.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design that consumes minimal system resources and prevents freezing.Familiar user interface ensuring a seamless migration with zero learning curve.Built-in robust PDF toolkit for viewing, editing, and converting PDF documents.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my split Access database keep losing connection?

This often happens due to temporary network drops, insufficient folder permissions on the back-end server, or known bugs in specific builds of Access 2019 affecting ADODB recordsets.

What is optimistic locking in Microsoft Access?

Optimistic locking is a concurrency control method where a record is only locked at the exact moment it is being updated or saved, allowing multiple users to read the data simultaneously without interference.

Do both the front-end and back-end need to be in a Trusted Location?

Yes, for optimal performance and to prevent security warnings or macro-blocking features from interfering with ADODB connections, it is highly recommended to add both the front-end and back-end folder locations to the Access Trust Center.