see records have been updated in a table from an update query

[Guest]

Is there anything without adding an extra field - such as date modified (not
it) since doesn't change with update query- where you can see that the
records have been updated with the update query???

thanks,
Barb

 

[Guest]

You could have a Change History table that compares everything on close of
the database and appends a record for everything changed from the last time.