KS DB Merge Tools logo KS DB Merge Tools
Documentation
AccdbMerge logo for MS Access
aka AccdbMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
KS DB Merge Tools for Cross-DBMS logo

Data Merge Warning Dialog

This dialog can be displayed to request parameters for the upcoming data merge/delete execution. The dialog is triggered by the Merge or Delete actions in the Data diff tab.

for MS Access, data merge warning dialog

The Free version excludes some options and just warns about potential limitations instead:

for MS Access, data merge warning dialog (free version)

Once the confirmation is OK, the next step is the execution of merge/delete operation with some progress indication.

The dialog contains the following sections.

Action

This section is always displayed.
You're going to {merge or delete} selected rows
Target database: {Database display name}

Backup

This section is always displayed.
Data merge and deletion does not make any backup, please make sure that you've done it yourself if needed.

Auto-generated primary key values

This section is shown under the following conditions:
- this table has AutoNumber primary key,
- it is a merge action (not delete),
- Data diff tab from where the dialog is called has filter that can include new rows (show all, or new, or new and changed)
Section content:
If disabled, DB engine will generate new values which most likely will be different
Import existing AutoNumber values for new rows

Merge all pages

This section is shown when you select all rows in the data diff and want to perform a batch merge or delete action on them, provided that the table has more rows on other pages. The Standard version asks if you want to process all pages:
You've selected all rows on the current data page, but there are more rows on other pages.
Do you want to process all rows from all pages?
Process all pages
The Free version simply warns that only the current page will be processed:
You've selected all rows on the current data page, but there are more rows on other pages which are not going to be processed.

Transactions

This section is always displayed.
Wrap table data operations in a transaction on the target database, with rollback on any first failure.
Can also provide better performance.
With transaction
If enabled, application calls BeginTrans() DAO call before rows processing, and CommitTrans() in the end of successful execution. If any row fails, then execution is stopped and Rollback() call made.

Default values

The default state of Auto-generated primary key values, Merge all pages, and Transactions options is taken from previous confirmation.

Free Version Limitations

  • Merge all pages is just a notification.

Last updated: 2025-07-18