If you have audit history enabled on your SQL Server database, the details of any record
change are stored in the audit log. You can access a record of the changes made to records, and
select a previous version of the record to be saved as the current state.
About this task
Records can only be reverted to versions that are stored in the audit history. If an
earlier version was created before the audit history was enabled, you will not be able to revert to
that record. In addition, you cannot revert the changes to a datasheet, but only to individual
records.
Procedure
To work with previous versions of a record:
-
Open the record directly (not using a datasheet), and select
Revert.
The record will open with a slider bar at the top to
navigate the versions of the record.
- Use the slider, to move between different versions of the record.
As details
change between versions, the differences between field values when compared to the current version
are highlighted in the display.
- If you would like to revert to an earlier version of the record, select that version and
click Save.
A new version of the record will be saved with the
same field values as the earlier version.
