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.

Total Access Detective Manual and CD

Microsoft Access 2016 Version is shipping!

New Features

New Version 15.5 for
Access 2013

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

Version 8 for
Access 97

View all FMS products for Microsoft Access All Our Microsoft Access Products


"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

Readers Choice Award
Best Debugging Tool

Detective Info

Why Detective?

Additional Info



Free Product Catalog from FMS