Courses > Access > TechHelp

In today's lesson I'm going to show you how to backup a record in your database before someone makes changes to it. This way you have a complete history of all of the edits, in addition to a date/time stamp of when it was edited.

TOPICS COVERED:

• Making a Backup Table
• Change AutoNumber to Long Int
• DateUpdated Field
• NOW() Function
• Append Query Warning Messages
• OnDirty Event
• DoCmd.SetWarnings
• Confirm Action Queries