| Total Access Detective | |
|
Versions available for Microsoft Access 2003, 2002, and 2000! Also
available for |
|
| Why Detective? | |
| Detective Info: | |
|
|
|
| Get Detective Now: | |
|
|
|
| "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 | |
|
|
|
Total Access Detective includes several reports for viewing the differences between objects in a database.
Object Comparison Reports
Object Differences Report
Shows the differences between the selected tables, fields, data
access pages, queries, forms, reports, controls, command bars, or
permissions.
Data Differences Report
Shows the data differences between the selected tables. Includes key
fields for the new and modified records, along with the number of
fields that differ, the field names, and the actual differences.
Macro Differences Report
Shows the differences between macros selected for comparison.
Shows the 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
Shows the differences between modules selected for comparison.
Shows the complete source code for the selected modules. Includes line numbers, which are reset to 1 at the beginning of each macro name.
Database Comparison Reports
Database Comparison Summary Report
Shows a summary of the
database comparison.
Objects in Both Databases Report
Shows a list of objects that have identical names and object
types in both databases, along with their modification dates and
whether they were selected for comparison.
Objects with Differences Report
Shows a list of objects that exist in both databases that have
differences with the number of property and/or code differences in
each, plus a summary by object type.
Objects Not in One Database Report
Two reports are available to show objects only in one of the two
databases: Objects in Database 1 Not in Database 2 and
Objects in Database 2 Not in Database 1.
Identical Objects in Both Databases Report
Shows objects selected for comparison that do not have differences.
Object Differences Report
Shows
the differences between the tables, fields, data access pages,
queries, forms, reports, controls, command bars, and permissions
selected for comparison.
Data Differences Summary Report
Shows a summary of the data differences between the selected tables.
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.
Macro Differences Report
Shows the differences between macros selected for comparison.
Shows the 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
Shows the differences between modules selected for comparison.
Shows the complete source code for the selected modules. Includes line numbers, which are reset to 1 at the beginning of each macro name.
Errors Report
Shows any errors encountered by Total Access Detective during the
comparison process.
