Track Changes to Data - Audit Trail - Log User Activity - Record Edits
Do you want to keep a log of any changes that are made to records in your database? In this video, I'll show you how.
Allison from Tennessee (a Gold Member) asks, "I've got a few different users who work with my database. Is there a way I can track what information they change?
Append Query: https://599cd.com/append
SQL Basics: https://599cd.com/sql
Security Seminar: https://599cd.com/security
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video covers tracking changes to just sensitive fields, such as "Customer ID 4 credit limit changed from $5000 to $9000." We'll also build a simple user combo box on the Main Menu so you can track WHICH user made changes to records.
MEMBERS ONLY VIDEO:
BECOME A MEMBER:
OldValue Property: https://599cd.com/oldvalue
Double-Double Quotes: https://599cd.com/XCQKJ
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: firstname.lastname@example.org
log user activity
track changes in field data
Please feel free to post your questions or comments below. Thanks.