Total Access Detective finds the differences between any two objects in one Microsoft Access database, including fields, controls, properties, macro lines, module code, and data.
Does Total Access Detective find data differences between tables?
Yes. With Total Access Detective, in addition to finding differences between the designs and structures of tables, there is an option to detect differences between data in two tables. The results are displayed in a list of new and modified records. For modified records, the fields which differ and their values are documented. The list can be printed or exported to your database where you can use it to link to your tables to retrieve the records.
Note that if you are comparing data between two databases, the comparison is performed between the tables stored in those two databases and not for linked tables. If you want to compare data in the linked database, point to that database directly.
For more info, visit: Compare Records (data) Between Microsoft Access Tables and Queries