In this use case, we summarize data differences across multiple tables or queries in two MS Access databases. You’ll get total, new, and changed row counts per object. After analysis, you can merge selected changes. This feature is available only in the Standard version.
Open databases (see the Project Changes Summary use case) and click A Batch data diff toolbar button.
Specify B calculation type, C whether to process tables or queries (or both), and D click Run.
Wait for progress to complete — you'll see the result at E.
Click Show only new and changed at F to filter and display only objects with data differences.
Select tables to merge at G and click Merge at H.
In the opened merge configuration dialog, specify I Scope and data options, review other settings, and click OK at J.
After merge completion K row counts updated, demonstrating successful merge result. Tables that no longer have any changes corresponding to the current New and Changed filter - excluded from the result (like Order Details)