You can track the data changes made to the Access database, if you used the Data Load Tool to make those changes (i.e., by loading or updating data using the Data Load Tool). The data changes are logged to the Data Load Tool created table [ztblTrackDataChanges] in the Access database. If this table doesn't exist in the database, it is created by the Data Load Tool when you load data. Note that these changes are only tracked if you commit the changes to the Access database (i.e., when you say yes to saving the changes to the Access database on the Finalize Data Load dialog, that appears after you have viewed the Data Load results/statistics).  

The following standard columns are included in the [ztblTrackDataChanges] table:

[UID] column contains auto numbered values to give a unique ID for each transaction (row) in this table.

[Timestamp] column indicates the date and time the [ztblTrackDataChanges] table was updated with this transaction. Note that when writing scalar values (e.g., date of birth, gender) multiple value may be written at once and they will have the exact same timestamp. However, arrays are written one row/value at a time, so each array related row may have a slightly different timestamp (even though they were added in the same data load).

[UserID] column contains either the Windows user name or the [USER] NAME from the ProAdmin.ini file. If you want the Windows user name, then make sure to blank or comment out NAME in the [USER] section of the ProAdmin.ini file.

[PersonID] column contains the Person ID (e.g., SSN) of the person who owns the data. This field is chosen in the Data Source section of the Data Load Tool and read in from the source database.

[TableName] column contains the name of the table that contains the current value.

[FieldName] column contains the name of the field (in the [TableName] table) that contains the current value.

[StartDate] column is either NULL or the effective date/start date if the value was in an array.

[StopDate] column is either NULL or the stop date if the value was in a start/stop date array.

[OldValue] column is either NULL or the value in the database before an UPDATE was performed. For example, if you are loading data for a new person (i.e., no data exists in the Access database for this PersonID), then there is no old value, so [OldValue] contains null. If you were updating the database with data changes, e.g., DOB changed from 2/3/1997 to 3/2/1997, then [OldValue] would contain 2/3/1997 and [NewValue] would contain 3/2/1997.

[NewValue] column is current the value in the database as of the time the last INSERT INTO or UPDATE was performed.

[Action] column will contain a 1 if the data was loaded (i.e., using INSERT INTO) or a 2 if the data was updated (i.e., using UPDATE).