Fix Microsoft Access Record Locking and Back-End Connection Error
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.

- 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.
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.
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.
Launch Microsoft Access, click on the 'File' tab in the top left corner, and select 'Options' located at the bottom of the navigation pane.
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.
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'.

Verify Folder Permissions on the Network
Since split databases rely on constant connectivity and file modification, ensuring appropriate folder permissions is crucial to prevent the back-end from locking up.
Revert Access to an Earlier Version
If the issue started after a recent Office update, rolling back to an earlier build of Access 2019 may bypass this known ADODB record-locking bug.
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.

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.




