Log Changes Made to Data in Microsoft Access at the Table Level Using a Data Macro
HTML-код
- Опубликовано: 31 июл 2024
- 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?
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Log Changes to Tables: 599cd.com/LogChangestoTables
PREREQUISITES:
Split Your Database: 599cd.com/Split
LINKS:
Track Changes: 599cd.com/TrackChanges
Track Log On: 599cd.com/TrackLogon
Data Macro: 599cd.com/DataMacro
RECOMMENDED COURSES:
Access Advanced 6: 599cd.com/ACA6
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, 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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Great video, Richard! I learned something (data macros) new today!!!
Thanks
Love me some data mackerels
Would it also be possible to let the logfile show “record edited from [old value] to [new value]” ?
SUBSCRIBE !!!SUBSCRIBE !!! SUBSCRIBE !!! FOR RICHARD'S HARD WORK & VALUABLE TUTORIALS . THUMBS UP TO THE GREATEST ACCESS TEACHER RICHARD. THANK YOU