Total Access Detective performs detailed comparisons between two tables to tell you exactly what's different. Compare two tables in one database or identically named tables in two databases (MDB, ADP, or ACCDB formats).
Total Access Detective makes it easy to find changes to your tables:
Visit finding the data differences between two tables to learn more about comparing records and the advanced options for comparing tables with different field definitions. After performing the data comparison, you can also choose to combine the data into a new table.
When comparing two tables, you can compare the object (table design structure) and/or data:
If you choose Object and Data, the results are displayed in a form with three tabs:
Example of Table Comparison Showing Field and Property Differences
Example of Data Comparison Showing New and Modified Records
Display of the Modified Field Values in Modified Records
For additional information on comparing data and the many options Total Access Detective offers, visit Compare Records (data) Between Microsoft Access Tables and Queries
Reports are available for:
Reports can be printed, previewed, opened in Report View, or exported to a variety of formats such as PDF, HTML, text, etc.
New Version 14.5 for
New Version 12.9 for
Version 11.8 for
Versions 10.7 and 9.7 for
Access 2002 and 2000
Version 8 for
"Total Access Detective is well worth every penny, it will quickly pay for itself through savings in time and effort."
Tom Cryan, Denver Access User Group product review
PDF Fact Sheet