Meeting
Pacific – Create Auditing in an Access Database with 3 Mouse Clicks with George Hepworth
- This meeting has passed.
Loading timezone…: Loading time…
Please join us for our Monthly Chapter Presentation November 6, 2025, at 6:30PM Pacific (UTC -8)
With an assist from my team of personal assistants, Claude and Chatty, I created a three step process to add lightweight auditing to an Access database application. It’s built on Data Macros to ensure data changes are captured.
Step one: Create the Admin tables required
- Audit table to track additions, modifications and deletions, including Long Text fields, which are not natively supported by Data Macros
- Configuration table to identify tables and fields eligible for audit.
- LongTextBackup table to support auditing of Long Text fields.
Step two: Populate the configuration table with tables, fields, datatypes and Primary Key values for the current database
Step three: Build the three Data Macros for each eligible field in each eligible table.
- AfterInsert
- AfterUpdate
- AfterDelete
I’ll demo the resulting audit function in a client application.
I’ll share the module that builds the audit function.
If time permits, I’ll add an admin interface for the process. As it stands now, I have to run three Sub procedures from the immediate window in the VBE.
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
==============================================================================
Please prepare ahead of time by downloading Zoom, if you don’t already have it.
Get Zoom
To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:
When it’s time, join the meeting from here:
Join Zoom Meeting
If you are asked:
Meeting ID: 852 1966 9601
Passcode: 123456
Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: 123456
Find your local number
