Total Access Detective

Total Acess Detective Manual

Microsoft Access 2016 and 2013 Versions
are Shipping!

New Version
New Version 14.5 for
Access 2010

New Version 12.9 for
Access 2007

Version 11.8 for
Access 2003

Versions 10.7 and 9.7 for
Access 2002 and 2000

Access 97 Version

View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Detective Info:

Why Detective?

Product Reviews 

"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

More Reviews

Additional Info:


Find differences between Microsoft Access databases and objects with Total Access DetectiveMicrosoft Access Object and Database ComparisonsDetect differences between Microsoft Access databases, object designs and data with Total Access Detective

Merge Data From Two Microsoft Access Tables into a New Table

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:

Options for Combining Records from Two Tables

A variety of options let you specify how the table should be created and populated:

Options for merging data from two Microsoft Access tables into a new table
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:

Table Name

The name of the new table. You are prompted to overwrite it if it exists.

Create New Table From

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.

Records to Include

You can optionally decide which records to include in the new table:

  • All identical records
  • New records in table 1 (they don't exist in table 2)
  • New records in table 2 (they don't exist in table 1)
  • Modified records. If you choose this, specify whether you want the changed record from table 1 or 2.

When you press [OK] the new table is created in your database.

Additional Resource