Versions of records

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:

  1. 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.

  2. 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.

  3. 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.