Others

How to Track Who Last Modified or Saved a Microsoft Access Database

Elise WilliamsElise Williams Nov 2, 2026 871 views

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.

How to Track Who Last Modified or Saved a Microsoft Access Database
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.
Before you start

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?

Solution 1Recommended

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.

1
Add tracking fields to your table

Open your Access table in Design View. Add two new fields: 'LastModifiedBy' (Short Text) and 'LastModifiedDate' (Date/Time).

2
Open the VBA Editor

Open the form used for data entry in Design View. Press ALT + F11 to open the VBA editor.

3
Use the BeforeUpdate event

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.

4
Assign values to the fields

Set your VBA code to assign these captured values to your 'LastModifiedBy' and 'LastModifiedDate' fields right before the record is saved.

Implement VBA or Data Macros for Record-Level Tracking
Data Macros Alternative: If you are using Access 2010 or newer, you can also use Data Macros (Before Change events) directly on the table to accomplish this without relying on form-level VBA.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and click 'Free Download'.
  2. 2. Install the suite: Run the lightweight installer to quickly set up the software on your computer.
  3. 3. Open your files: Easily open, edit, and save your existing .docx, .xlsx, and .pptx files with zero formatting loss.
Fully compatible with Microsoft Word, Excel, and PowerPoint formatsLightweight application that runs smoothly even on older devicesFree to use with a familiar, easy-to-navigate interfaceBuilt-in robust PDF editing and conversion tools
microsoft office alternative - wps office

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.