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

Post Your Comments

Only students may post right now.
Click here for more
information on how you can set up an account. If you are a student, please LOG ON first.