FMS Home FMS Software Development Team Blog FMS Facebook Page FMS Twitter
Jump: Search:

Total Access Detective

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 Microsoft Access Report Differences

Total Access Detective performs detailed comparisons between two reports to reveal exactly what's different. Compare two reports in one database or identically named reports in two databases.

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

  • Report Properties (recordsource, caption, description, etc.)
  • Controls
    • Control Names on one report but not on the other
    • Control Type and other properties for identically named controls
  • Section Properties
    • Report Header and Footer Properties
    • Page Header and Footer Properties
    • Grouping section properties
    • Detail Properties
  • Embedded Macros at the report, section, and control levels
  • Module Code behind the report

Comparing Microsoft Access Reports

When comparing two reports, you can compare the object (report design) and/or module code:

Compare Microsoft Access form properties, modules, or both

Module comparison has the same options as comparing two standard modules.

Options for Comparing Microsoft Access Module Text

Here's more information on module comparison options.

Report Comparison Results

If you choose Object and Module, the results are displayed in a form with four tabs:

  • Object: property, control, and section differences
  • Module Differences:
    • Procedures that exist on one report and not on the other
    • Line by line comparison of identically named procedures
  • Identical Procedures: list of procedures with no changes
  • Embedded Macros: line by line comparison of embedded macros

Design Differences Between Two Reports

Difference between two Microsoft Access reports showing controls in one but not the other, property and section differences
Example of Report Comparison Differences

Module Differences Between Two Reports

Differences bewteen modules for code behind reports in Microsoft Access
Example of Module Code Behind Report Differences

For additional information on how Total Access Detective compares modules, visit Finding Microsoft Access Module Differences (VBA)

Reports for Report Differences

Reports are available for:

  • Report Design Differences
  • Embedded Macro Differences
  • Module Differences
  • Identical Procedures
  • Printouts of each report's entire module

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

Total Access Detective Home


Contact Us  l   Web questions: Webmaster   l   Copyright FMS, Inc., Vienna, Virginia
Celebrating our 28th Year of Software Excellence