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

Toolbar actions

Most common actions are always shown in toolbar, however they can be disabled if this action is not applicable in the current situation. For example, Find toolbar is disabled until you open any database.

Some other actions are more specific to some concrete tabs and hidden at all for other tabs. For example, Compare selected is shown only for the Object list tab.

Action                            Keyboard shortcut Description Applicability           
 Open file(s) Ctrl+O Opens standart file open dialog to choose Microsoft Access or *acdms file(s) to open
 Open protected files Ctrl+Shift+O Opens Open protected files dialog
 Batch data diff Ctrl+Shift+B Opens Batch data diff tab
 Query result diff Ctrl+Shift+Q Opens Query result diff tab
 Custom data diff Ctrl+Shift+C Opens Custom data diff dialog
 Find Ctrl+F Open Find tab
 Refresh Ctrl+Shift+R Refresh information from database for the active tab Home tab
Object list
Data diff
 Export to Excel Ctrl+Shift+E Open Excel report for the active tab Home tab
Object list
Data diff
Batch data diff
Query result diff
 Copy selection to clipboard Ctrl+C Copy selected data grid cells or text lines to clipboard. Use Shift key to select multipe cells/rows Object list
Data diff
Text diff
Query result diff
 Show all records Ctrl+F1 Show all records in the primary data grid of the current tab Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new and chagned records Ctrl+F2 Show only new and chagned records in the primary data grid of the current tab Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new records Ctrl+F3 Show only new records in the primary data grid of the current tab Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only chagned records Ctrl+F4 Show only chagned records in the primary data grid of the current tab Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Next change Alt+Down Jump to the next new/changed row/record Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
 Previous change Alt+Up Jump to the prevous new/changed row/record Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
 Select all on the left Select all records in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Select none on the left Unselect all records in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Invert left selection Ctrl+A in the active grid Invert selection in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Merge to right Ctrl+M Merge to the right selected records from the left Object list
Data diff
Table structure diff
 Delete selected on the left Ctrl+D Delete selected item(s) on the left side Object list
Data diff
Table structure diff
 Select all on the right Select all records in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Select none on the right Unselect all records in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Invert right selection Ctrl+A in the active grid Invert selection in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Merge to left Ctrl+Shift+M Merge to the left selected records from the right Object list
Data diff
Table structure diff
 Delete selected on the right Ctrl+Shift+D Delete selected item(s) on the right side Object list
Data diff
Table structure diff
 Settings Opens Settings dialog
 Use DB Engine from Access application toggle For data diff: if unchecked, then AccdbMerge uses Access Database Engine installed to the system (see Why I might need AccessDatabaseEngine on the product web site). If unchecked then it will open MS Access to read/modify data
 Zoom out application Ctrl+Minus Zoom out application UI, decrease scale of all UI elements
 Zoom in application Ctrl+Plus Zoom in application UI, increase scale of all UI elements
 About license Opens License info dialog

Last updated: 2022-02-22