Find differences between Microsoft Access databases and objects with Total Access Detective

Microsoft Access Object and Database Comparisons

Detect 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.

Report Differences Detected

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

Options for Comparing MS Access Reports

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

Compare Microsoft Access report 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.

MS Access 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

Difference between two Microsoft Access reports showing controls in one but not the other, property and section differences

Design Differences Between Two Reports

See controls, sections, groups, and property differences between two reports.

Filter to only show controls, groups and sections in one report but not the other

Controls in One Form but Not the Other

Quickly filter to see the objects (groups, sections, and controls) that exist in one report but not the other. They may have been added, deleted, or renamed.