How to Show the User Editing a Locked Access Record
Question details
The user wants to display a message identifying the specific person who is currently editing and locking a record in a Microsoft Access form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Multiple users are entering data into an Access database. When one user tries to edit a record already being modified by another, they need to see exactly who holds the lock to coordinate edits.
- Observed behavior
- Access uses the 'Edited Record' locking option to prevent simultaneous edits but does not have a native form property to display the username of the person holding the lock.
Verify whether your Access database uses a SharePoint list as its backend, as this determines the most effective method for tracking user locks.
Expose the Editor via SharePoint List Views
Since Access lacks a built-in property for identifying the locking user, leveraging SharePoint's native checkout feature is the most reliable method when your backend is a SharePoint list.
Log in to SharePoint and navigate to the list that serves as the backend data source for your Access application.
Click on the view options menu (usually at the top right of the list) and select 'Edit current view' or create a new custom view.
Scroll through the available columns and check the box next to 'Checked Out To'. Save the view settings.
Instruct your database users to check this SharePoint list view whenever they encounter a locked record in the Access form, allowing them to easily see who has the record checked out.

Build a Custom User Tracking System using VBA
Create a dedicated logging system in Access to manually track when users enter and exit a record.
Try WPS Office for Seamless Document and Spreadsheet Management
While Microsoft Access is a specialized tool for databases, WPS Office provides a free, lightweight, and comprehensive suite for all your daily document, spreadsheet, and presentation needs. Enjoy high compatibility with Microsoft Word, Excel, and PowerPoint without heavy subscription costs.
- 1. Download the software: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the quick on-screen instructions to set up the suite on your device.
- 3. Open your files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint documents with perfect formatting preservation.

Frequently Asked Questions
Does Microsoft Access have a built-in feature to show who locked a record?
No, Access does not provide a reliable built-in form property that returns the name of the user holding a record lock. Workarounds like custom VBA tracking tables or checking backend configurations (e.g., SharePoint 'Checked Out To') are required.
Why do I get a 'Could not update; currently locked' error?
This error occurs when the database form is set to 'Edited Record' locking. This setting prevents multiple users from saving conflicting changes to the same record simultaneously, which helps avoid data corruption.
Can I use VBA to identify the user locking an Access record?
Native VBA functions cannot directly extract the locking user's name from Access's internal lock file (.laccdb). To achieve this, you must design a separate, custom user-tracking table and update it via form events (like On Dirty and After Update) when users modify records.




