Log Data Changes in Microsoft Access with Data Macro

In this Microsoft Access tutorial, I will show you how to log changes to tables at the table level using data macros, ideal for shared databases with custom front ends. Discover how to audit record additions and modifications without VBA, ensuring database integrity even when you can't control user interfaces.

Derek from Grapevine, Texas (a Platinum Member) asks: I have a unique situation in my office where there are 5 of us working on the same Microsoft Access data in a backend database, but we all use our own custom front ends because we all know how to work with Access, and people like to make their own forms and reports and queries and such. That's fine, but for auditing purposes, I need to know when certain records were changed or added. Since I can't put any controls in at a VB level in the forms, is there any way to audit what was done in the tables directly?

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Split Your Database

Links

• Track Changes
• Track Log On
• Data Macro

Recommended Courses

• Access Advanced 6

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, data macros, table-level auditing, track changes Access, log data modifications, back-end database, record changes Access, Access auditing without VBA, audit trail in Access, monitor data updates Access, after insert data macro, after update data macro, user-independent auditing Access, track record additions Access, before change data macro, log user activity Access, multi-user database Access