Features

Batch Data Diff

Batch Data Diff allows to compare data for multiple tables and queries. This tool can be opened using 

 toolbar button:

Comparing number of new or changed records will provide you more information, but these operations are more time-consuming. You can compare not only tables, but also you can queries data. However, for queries new and changed records count can not be calculated since they do not have primary keys and therefore it is not possible to detect whether the record was added or changed.

Custom Data Diff

Custom Data Diff allows to compare any tables and queries with ability to specify custom field mapping. At least one field mapping item must be defined with mapping type "Key". This tool can be opened using 

 toolbar button:

.

Export to Excel

Export to Excel generates Excel reports for object list, data diff, batch data diff and table structure diff. Click the 

 toolbar button to export data grid from the currently opened tab:

For the data grids that allow record/object selection (such as table diff view), only selected records will be exported, if any records were selected.

Support of password-protected files

You can open password-protected files using 

 toolbar button or "with password" link on the project tab:

 and "Previous change"  toolbar buttons to search for the next/previous block of changes in the data diff and text diff views.

No data diff and merge limitations

AccdbMerge Free provides basic data diff and merge facilities with the following limitations:

- both tables must have compatible primary keys,

- no more than 50 fields,

- no multivalue/attachment/binary fields,

- data merge is supported only for tables with numeric primary keys.

Pro version does not have these limitations. Also, it allows to compare data between files with different security options.

Support of *.mde and *.accde files

AccdbMerge Pro supports compiled '.mde and *.accde files. Of course, modules, forms and reports can't be compared by content for such files, but all other objects and data will be processed as usual.

Queries data diff and merge

You can compare query results the same way as for tables using "Compare data"  and  buttons. Click on these buttons will bring up a "Define query key fields" dialog with the list of common fields. Select number of fields that can uniquely identify query row to detect new and changed records. When you click OK, AccdbMerge Pro checks that chosen fields match this criteria, otherwise you will get a warning and will have to select other fields.

Some queries that considered as updatable by Access also allow to merge data. 

Fields and their properties diff and merge

Clicking on the table name in the tables list will open a table structure diff window:

Here you can merge field definitions, field properties (such as input mask or validation rule), indexes and table relationships used by this table. Field definitions currently being merged without data, once you have merged some field definition, you can use table data diff to merge data for this field.

Field properties diff and merge requires loading additional data, which make file open process much slower. If you are not going to merge fields, then most likely you don't need to load field properties. This can be configured using application settings window.

Command line arguments support

You can open projects in AccdbMerge Pro using command line arguments. This makes it possible to use AccdbMerge Pro as a diff viewer for version control system clients such as TortoiseSVN. The format of command line arguments is

accdbmerge.exe left_file_full_path right_file_full_path

Table indexes and relationships diff and merge

You can compare and merge indexes and relationships from table structure diff window mentioned above. Also, relationships are presented as a separate group on the project tab, so you can observe all database relationships using object list window.

VBA project references diff

VBA project references are presented as a separate group on the project tab and you can compare list of application references in the object list window.

Extended diff facilities

Object list, data diff and text diff views provide the following additional diff tools:

- total, new, changed and new+changed record/line counts,

- display selected row in the separate vertical side-by-side comparison panel,

- paging in data diff allows you to work with really large amounts of data,

- sorting in data diff will help you to arrange and find required records.

Below are the sample screenshots.

Object list view:

Data diff view:

Text diff view:

Other enhancements

- By-character comparison inside changed rows for text diff view,

- Find tab - drill-down links to occurrence with focus on target row in the text diff view,

- Copy to clipboard support for text diff, object lists and table diff views,

- More stable handling of database locks during project load and object import,

- Open file progress dialog,

- Ability to load only particular object types.