One of the most powerful features of Total Access Detective is its ability to combine (merge) data between the two tables you compared. This is extremely useful for reconciling changes made to two copies of the same table.
After Total Access Detective finds different records between your Microsoft Access tables, view the results and press the [Combine] button:
A variety of options let you specify how the table should be created and populated:
Options for Merging Data from Two Tables
The example above is from comparing two tables in your current database. For two database comparison, the table names are identical and you specify the database where the new table is created. All the other options are identical:
The name of the new table. You are prompted to overwrite it if it exists.
Specify which of the two source tables becomes the design of the new table. The new table uses this source's field names, properties, indexes, etc.
You can optionally decide which records to include in the new table:
When you press [OK] the new table is created in your database.
New Version 15.5 for
New Version 14.5 for
New Version 12.9 for
Version 11.8 for
Versions 10.7 and 9.7 for
Access 2002 and 2000
Version 8 for
"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