Total Access Detective

Total Acess Detective Manual

Microsoft Access 2016 and 2013 Versions
are Shipping!

New Version
New Version 14.5 for
Access 2010

New Version 12.9 for
Access 2007

Version 11.8 for
Access 2003

Versions 10.7 and 9.7 for
Access 2002 and 2000

Access 97 Version

View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Detective Info:

Why Detective?

Product Reviews 

"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

More Reviews

Additional Info:


Find differences between Microsoft Access databases and objects with Total Access DetectiveMicrosoft Access Object and Database ComparisonsDetect differences between Microsoft Access databases, object designs and data with Total Access Detective

Total Access Detective

Detect Differences Between Any Two Objects or Databases!

Total Access Detective Logo
Information Booth
bullet Product Summary
bullet Features
bullet How Total Access Detective Works
bullet Pricing and Availability
Other Related Links
bullet Enhancements in Version 8.0
bullet Independent Reviews
bullet Total Access Detective Reviewed!
Denver Access Area User Group Newsletter review raves about Total Access Detective
1998 Readers' Choice Award
Best Debugging Tool
1996 Readers' Choice Award
Best Debugging & Testing Tool

Total Access Detective Product Box

See the
Current Version!

Click Here!

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

Product Summary

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 Features

Compare Any Two Objects in One Database

  • Tables: fields, indexes and properties
  • Queries: fields, parameters and properties
  • Forms and Reports: properties, controls and module code
  • Macro and Module Lines

Compare Any Two Databases

  • Quickly list modified (identically named) objects
  • Determine objects in one database, but not the other
  • Select objects for detailed comparisons
  • Compare table relationships
  • Compare object permissions

Compare Data between Tables

  • Detect new and deleted records
  • Detect modified records and the field differences

How Total Access Detective Works

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.

Pricing and Availability

Total Access Detective is available for Microsoft Access 97 through 2010. This product is available as a single product or part of a multi-product suite.

Total Access Detective Products
by Microsoft Access Version

Licenses Price 2016 2013 2010 2007 2003 2002 2000 97

Single $199
5 Seat $599

Upgrade Between Access Versions

Single $119
5 Seat $349

Upgrade to Latest within the Same Version (14.5 for 2010, 12.9 for 2007, 11.8 for 2003; X.7 prior)

Single $69  
5 Seat $199  

Premium Support Subscription

Single $299

More Information

5 Seat $999

Also Available as part of:

Total Access Ultimate Suite
Total Access Developer Suite

Runtime/Redistributable Version

Not Applicable

Licensing Information

Total Access Detective is licensed on a per developer basis. Each developer who runs the program must have a license. Read the License Agreement for details.