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

Total Access Detective Sample Reports

Total Access Detective includes many reports for viewing the differences between your Microsoft Access objects and databases. The reports are organized by the two comparison options:

Object Comparison Reports
Database Comparison Reports

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

Object Comparison Reports

These 8 reports are available when Total Access Detective is run as an add-in to compare two objects in the current database.

Object Property Differences Report

Differences between the selected tables, fields, data access pages, queries, forms, reports, controls, command bars, or permissions.

Fields Compared for Data Differences Report

Field names that matched for data comparison, and whether it is a key field.

Data Differences Report

Data differences between the selected tables and queries.

Includes key fields for the new and modified records, along with the number of fields that differ, the field names, and the actual differences.

Field Differences of Modified Records Report

Data differences for modified records side by side to compare changed values between tables and queries.

Macro Differences Report

Differences between macros by macro name and lines.

Macro Printout Report

Complete source code for the selected macros. Includes line numbers, which are reset to 1 at the beginning of each macro name.

Module Differences Report

Differences between modules.

Module Printout Report

Complete source code for the selected modules. Includes line numbers, which are reset to 1 at the beginning of each procedure name.

Database Comparison Reports

These 16 reports are available when you compare two database to see objects in one and not the other with detailed analysis between identically named objects.

Database Comparison Summary

These reports show the top-level differences between the databases from objects in one and not the other, identically named objects, an overview of the differences detected, and warnings of any errors encountered during the comparison.

Summary of Database Differences Report

Summary of the database comparison.

Objects in Both Databases Report

List of objects with identical names in both databases, along with their modification dates and whether they were selected for comparison.

Selected Objects with Differences Report

List of selected objects for comparison that have differences with the number of property and/or code differences in each, plus a summary by object type.

Selected Objects that are Identical Report

Objects selected for comparison that do not have differences.

Objects Not in One Database Report

Two reports to show objects only in one of the two databases: Objects in Database 1 Not in 2, and Objects in Database 2 Not in 1.

Identical Objects in Both Databases Report

Selected objects without differences.

Comparison Errors Report

Errors and warnings encountered by Total Access Detective during the comparison process.

List of Reports

List of the available reports and their export file names.

Differences Between Identically Named Objects

These reports show the detailed differences between the database objects including tables, queries, data, forms, reports, macros and modules.

Object Property Differences Report

Differences between the tables, fields, queries, forms, reports, controls, command bars, and permissions selected for comparison.

Data Differences Summary Report

Summary of the data differences between the selected tables and queries.

Data Differences Fields Compared Report

Table and query fields that were compared to each other during data comparison.

Data Differences Reports

Several reports are available to show the data differences between the tables selected for comparison: All Data Differences, New Records in Database 1, New Records in Database 2, Modified Records, and Non-Keyed Tables. These reports shows the key fields for the new and modified records, along with the number of fields that differ, the field names, and the actual differences.