Total Access Detective finds data differences between tables and queries in your Access databases. The data can be from an Access database or any linked table. New, deleted, and modified records are detected. For modified records, the different fields are identified.
Results are shown in forms for you to view, export to a table in your database, or print. A powerful Combine feature lets you merge data from your two source tables into a new table in your database.
Find changes to your data from:
For keyed tables (so matching records are compared), these differences are found:
The results are presented in these formats:
For tables without a key field or queries where the first field is not designated as the primary key, records are compared sequentially and the first record that's different is documented.
The data comparison results are shown on two tabs:
Every record that's different is shown with its primary key(s), difference type, and details. For modified records, the field differences, number of fields, and field names are listed.
For each modified record, every field difference is shown side-by-side
While viewing the results, there are several options:
A variety of options are available for you to customize how to compare the two data sets, and what's generated:
For keyed tables, the key field is automatically used to identify records for comparison. For unkeyed datasets, Total Access Detective's default behavior is to compare the records sequentially and identify the first record that's different, which tells you the tables do not contain the same data but not much more.
You can perform more advanced analysis if the first field defines uniqueness for each table. This is particularly useful when comparing queries which never have a key field. With this, new, deleted, and modified records can be identified.
Specify Sequential Comparison or the First Field as a Unique Identifier
Total Access Detective lets you compare data in tables with identical and "similar" structures by specifying the Field Comparison methodology:
Specify How Fields are Matched for Comparison
For every modified record, Total Access Detective creates a record documenting the difference and filling a memo field with details of every differing field and its values in the two records. This may be a lot of information. To reduce this, you can limit the maximum number of character per record and/or a limit on the amount of text to show for memo fields which are different.
Control How Much Data is Shown for Each Modified Record
The memo field containing all the field differences in a modified record can be stored with one field difference on each line along with its two values, or a separate line for each field value to make it easy to compare values visually.
Display Field Differences on One Line or a Separate Line for Each Field
Specify the level of numerical accuracy. Decide whether you want to see all numeric differences, or only differences that exceed a certain percentage. This lets you avoid small rounding errors and immaterial differences.
Specify the Minimum Percentage Difference for Comparing Numbers
Once data differences are documented, a powerful feature lets you combine the data from your two tables into a new table in your database. Visit Merge (Combine) Data from Two Microsoft Access Tables for more information.
"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
PDF Fact Sheet