Total Access Detective is another MUST HAVE product from the leader in Access analytical tools.
Michael Groh, editor of Access/VB Advisor
This add-in will save you many hours of difficulty when managing any Access application with multiple developers.
Michael Gunderloy, Smart Access
Total Access Detective is an object comparison wizard for Microsoft Access 2.0 and 97 databases. Use it to determine exactly what is different between two objects in one database or between two databases. This is particularly useful when you need to compare two different versions of your database, or databases in multi-developer environments. Every field, control, property, line of code, etc. is compared and differences shown. There are even options to compare data in tables and permission settings.
Total Access Detective is implemented as an easy-to-use Wizard. It runs from the within Microsoft Access and stores its results in tables in its own database. The product includes customizable reports, extensive on-line help, and a comprehensive user manual.
To compare two objects in one database, open the database containing the objects to compare, then launch Total Access Detective from the File|Add-ins menu. The Comparison Wizard lets you select the objects to compare and presents the detailed results.
To compare two databases, a Total Access Detective database is opened and you select the two databases. An quick analysis presents a list of modified objects (identically named objects), and objects in one database and not the other. You can choose some or all of the modified objects for more detailed analysis.
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