Total Access Detective performs detailed comparisons between two queries to tell you exactly what's different. Compare two queries in one database or identically named queries in two databases (MDB, ADP, or ACCDB formats).
Total Access Detective makes it easy to find changes to your queries:
Visit finding the data differences between two queries to learn more about comparing records and the advanced options for comparing queries with different fields.
When comparing two queries, you can compare the object (query design) and/or data:
If you choose Object and Data, the results are displayed in a form with three tabs:
Example of Query Comparison Showing 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