Рет қаралды 48,278
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?
LEARN MORE:
Append Query: 599cd.com/append
SQL Basics: 599cd.com/sql
Security Seminar: 599cd.com/secu...
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:
• Tracking Changes to Da...
BECOME A MEMBER:
/ @599cd
MEMBERS TOPICS:
OldValue Property: 599cd.com/oldv...
Double-Double Quotes: 599cd.com/XCQKJ
ADDITIONAL RESOURCES:
FREE Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/Tech...
Learning Connection 50% OFF: 599cd.com/Conn...
Survey: 599cd.com/survey
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/Acce...
Twitter: / learningaccess
Email Me: amicron@gmail.com
en.wikipedia.o...
products.offic...
microsoft.com/...
ADDITIONAL KEYWORDS:
log user activity
track changes in field data
audit trail
recording edits
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.