How to Track Who Last Modified or Saved a Microsoft Access Database
Question details
The user needs to know how to track which user last modified or saved a Microsoft Access database and when the changes occurred.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Auditing and tracking user modifications within a shared database environment to maintain data integrity and accountability.
- Observed behavior
- Microsoft Access does not have a built-in feature to automatically record which user edited a specific record or when the change occurred.
Determine the exact level of tracking you need: are you looking for the modification date of an individual table record, a specific database object (like a form or report), or the overall database file itself?
Implement VBA or Data Macros for Record-Level Tracking
Use this method if you need to know exactly which user modified a specific row of data and at what time. Since Access lacks a built-in audit trail, custom VBA code or macros are required.
To track edits at the record level, you must modify your database structure to include tracking fields and use VBA (Visual Basic for Applications) or Data Macros to populate them automatically.
This involves identifying the current user logged into the system and capturing the exact timestamp of the update.
Open your Access table in Design View. Add two new fields: 'LastModifiedBy' (Short Text) and 'LastModifiedDate' (Date/Time).
Open the form used for data entry in Design View. Press ALT + F11 to open the VBA editor.
In the form's BeforeUpdate event, write VBA code to capture the current user using Environ("USERNAME") and the current time using the Now() function.
Set your VBA code to assign these captured values to your 'LastModifiedBy' and 'LastModifiedDate' fields right before the record is saved.

Check Database Object Properties for Design Changes
Use this method if you only need to know when the design of a form, report, or query was last modified.
Check File Properties for Database File Modification
Use this method if you simply need to know when the entire database file (.accdb) was last saved or modified on your computer or network drive.
Looking for a Free, Lightweight Microsoft Office Alternative?
While WPS Office does not include a database management tool like MS Access, it is an excellent, free alternative for your everyday document, spreadsheet, and presentation needs. Enjoy seamless compatibility with Microsoft Office formats in a lightweight suite.
- 1. Download the installer: Visit the official WPS Office website and click 'Free Download'.
- 2. Install the suite: Run the lightweight installer to quickly set up the software on your computer.
- 3. Open your files: Easily open, edit, and save your existing .docx, .xlsx, and .pptx files with zero formatting loss.

Frequently Asked Questions
Does Microsoft Access automatically track who changed a record?
No, Microsoft Access does not have a built-in feature to track user modifications at the individual record level. You must implement custom VBA code or use Data Macros to record this information.
Can I see when a specific database object like a form was last modified?
Yes. By changing the Navigation Pane view in Access to 'Details', you can view the exact creation and modification dates for forms, reports, tables, and queries.
Is there a way to track record changes without writing VBA code?
If you are using Access 2010 or later, you can use 'Data Macros' attached directly to table events (like 'Before Change') to log the username and timestamp into an audit table without writing traditional VBA code.
How do I identify the current user in Access VBA?
You can identify the current Windows user by using the VBA function Environ("USERNAME"). This pulls the login name of the active user session on the machine.




