Others

How to Show the User Editing a Locked Access Record

Phi Hung VoPhi Hung Vo Nov 3, 2026 869 views

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.

How to Identify the User Editing a Locked Record in Access
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.
Before you start

Verify whether your Access database uses a SharePoint list as its backend, as this determines the most effective method for tracking user locks.

Solution 1Recommended

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.

1
Access your SharePoint list

Log in to SharePoint and navigate to the list that serves as the backend data source for your Access application.

2
Modify the list view

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.

3
Add the Checked Out column

Scroll through the available columns and check the box next to 'Checked Out To'. Save the view settings.

4
Inform users

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.

Expose the Editor via SharePoint List Views
Form Limitation: This method relies on checking the SharePoint backend directly, as Access forms cannot easily pull this specific locking data dynamically into the UI without complex custom setups.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the installer and follow the quick on-screen instructions to set up the suite on your device.
  3. 3. Open your files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint documents with perfect formatting preservation.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Lightweight installation with blazing-fast startup times.Familiar, intuitive tabbed interface for easy multi-tasking.Rich built-in PDF editing and conversion tools at no extra cost.
microsoft office alternative - wps office

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.