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

Toolbar actions

Toolbar has buttons for the most common application actions. Some of these actions have keyboard shortcuts. Some actions can be disabled at some moment of time: this action can be non-applicable for the current tab or for the current application state. Usually the action disable reason is shown in the toolbar button tooltip.

Action                            Keyboard shortcut Description Applicability           
 Open file(s) Ctrl+O Opens standard 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 Xlsx or Json Ctrl+Shift+E Generate Xlsx or Json report for the active tab Home tab
Object list
Data diff
Table structure 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 multiple cells/rows Home tab
Object list
Data diff
Text diff
Query result diff
 Show all Ctrl+F1 Show all rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new and changed Ctrl+F2 Show only new and changed rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new Ctrl+F3 Show only new rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only chagned Ctrl+F4 Show only changed rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only unchagned Ctrl+F5 Show only unchanged rows/objects/lines Home tab
Object list
Data diff
Query result diff
 Last change Alt+Shift+Down Jump to the last block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
 Next change Alt+Down Jump to the next block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
 Previous change Alt+Up Jump to the previous block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
 First change Alt+Shift+Up Jump to the first block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
 Select all on the left Select all rows in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
Table structure diff
 Select none on the left Unselect all rows in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
Table structure 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
Table structure diff
 Merge to right Ctrl+M Merge to the right selected rows from the left Object list
Data diff
Table structure diff
Batch data diff
 Delete selected on the left Ctrl+D Delete selected item(s) on the left side Object list
Data diff
Table structure diff
Batch data diff
 Select all on the right Select all rows in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
Table structure diff
 Select none on the right Unselect all rows in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
Table structure 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
Table structure diff
 Merge to left Ctrl+Shift+M Merge to the left selected rows from the right Object list
Data diff
Table structure diff
Batch data diff
 Delete selected on the right Ctrl+Shift+D Delete selected item(s) on the right side Object list
Data diff
Table structure diff
Batch data 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 checked then it will open MS Access to read/modify data. It may be useful in the following cases:
  • Access DB engine is not available
  • To compare compare queries and custom queries that use functions, for example Nz() or user-defined functions
  • To run custom queries against system tables like MSysObjects
  •  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
     Full screen F11 Switch application to the Full screen mode
     Online help F1 Opens online help page for the current tab
     About license Opens License info dialog

    Last updated: 2024-10-21