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

Compare and Find Differences Between Microsoft Access Macros (including Embedded Macros)

Total Access Detective performs detailed comparisons between two macros to reveal exactly what's different. Compare two macros in one database or identically named macros in two databases (MDB, ADP, or ACCDB formats).

Total Access Detective makes it easy to find changes to your macros:

  • Macro property differences (description, last updated, etc.)
  • Macros line difference for the main macro
  • Sub Macro names that exist in one macro and not in the other
  • Macros line differences for identically named sub macros

Embedded macros on forms and reports are compared when the form/report is compared. Embedded macros for the same event on identically named controls are compared.

Macro Comparison Results

Blocks of macro line differences are shown. For two database comparisons, all the identically named macros are compared and their differences shown:

Microsoft Access Macro Comparisons Line-by-Line
Example of Different Macro Line Commands

Reports for Macro Differences

Reports are available for:

  • Macro Line Differences
  • Printouts of All Lines for Each Macro
  • Macro Property Differences

Reports can be printed, previewed, opened in Report View, or exported to a variety of formats such as PDF, HTML, text, etc.