Access database comparison and synchronization with DTM Data Comparer

Any user without strong database experience can compare or synchronize two Access databases with DTM Data Comparer. The tool provides easy GUI with three steps.
The user should:

• Select databases files that contains Access tables to be compared.
• Select source and target tables from drop-down menu.
• Run the comparison or synchronization process.

How the tool compares access databases? The comparison software fetches data rows basing on the order of ascending of primary key values. The user can define alternate unique key for tables without a key.
The comparer marks by yellow background any row without the same key value for source an target table. Otherwise, i.e. values of the keys are equal, the program places them to the same lines and highlights for equal fields by green background and different fields by red background.
In case Access tables have different structure the user can apply column mapping. This feature allows to specify field correspondence between tables to be compared. The mapping window is also provide a way to convert data with built-in Access SQL function if necessary.

Download free demo version(?).