What's new in AccdbMerge 1.28.4
Apr 6, 2024
- Free & Pro: Home - fix bug 'Open single database, Refresh, and other side loaded with the same DB instead of refresh'
- Free & Pro: SQL syntax highlight - recognize multiline strings
- Free & Pro: What's new - enable word wrap for list of changes to avoid horizontal scroll for long items
- Free & Pro: Text diff - change line numbers to dark-gray to avoid visual confusion with actual text
- Free & Pro: Fix focus on selected tab, switching between data diff tabs and clicking Refresh could produce selection of some other previously focused tab
- Free & Pro: Data diff - add 'Click to sort by this column' column tooltip where applicable
- Pro: Data diff - ability to compare string values in the separate text diff tab: fix lost indication (arrows) after paging
- Pro: Data diff - ability to compare string values in the separate text diff tab: change indication from arrows to triangles
- Pro: Data diff - ability to compare string values in the separate text diff tab: add 'Click to compare value in the Text diff' tooltip
- Pro: Query result diff - fix cases of missing first row selection on Run (and therefore fix missing bottom row grid)
- Pro: Query result diff - clear previous result on subsequent Run
- Pro: Query result diff - handle properly cases when only one side result is available (error on other side, other side returned no table result)
- Pro: Query result diff - error text word wrap, ability to copy, and some other layout updates
- Pro: Text diff - new 'Show tabs and spaces' toggle
- Pro: Text diff - new bottom line implementation, with selectable text and fixed tabulation width
New in AccdbMerge 1.28.3 (Mar 27, 2024)
- Free & Pro: Data diff, Query result diff - fix false-positive changes caused by internal approximacy for dbSingle and dbDouble
- Free & Pro: EULA updated (divided into sections, more information and clarifications)
- Pro: Data diff - Allow to compare string values in the separate text diff tab (the up-right arrow near column name in the bottom grid, useful for multiline values)
- Pro: Query result diff - fix unexpected error on compare by row number then click result column name to sort
- Pro: Custom data diff - fix validation of sorting on more than one non-key column
New in AccdbMerge 1.28.2 (Mar 12, 2024)
- Free & Pro: Data merge/delete progress completion - mark 'with errors' message with red
- Free & Pro: Data merge/delete progress - add 'Open log' action to open detailed log on progress completion
- Free & Pro: VBA syntax highlight - add 'Not' to the keyword list
- Pro: Text diff - change Expand above/below links to folding sections (and fix some syntax highlight issues if it shows new/changed lines)
- Pro: Text diff - if show only new/changed lines, do not hide block containing only one line
- Pro: Text diff - show 'Additional lines' configuration directly in tab and remove it from Settings
- Pro: Processing of MDW-protected files - kill MS Access process if it was not released gracefully after database close
- Pro: Batch data diff - 'Copy all' and 'Open log' database progress actions appearing on merge/delete completion
New in AccdbMerge 1.28.1 (Mar 1, 2024)
- Free & Pro: SQL syntax highlight - highlight identifiers and numbers, reduced list of keywords to the most generally used
- Free & Pro: VBA Syntax highlight - update and reduce list of keywords, recognize strings, numbers and square-brackets identifiers
- Free & Pro: Disable syntax highlight for macros, forms and reports layout and layout+module modes
- Free & Pro: Splash screen
- Free & Pro: Updated application binary protection
- Free & Pro: App settings folder changed to %APPDATA%AccdbMerge (without trailing 'Pro')
- Free & Pro: Data merge/delete progress - save detailed log to the temporary file for better performance
- Free & Pro: Data diff - use the same fonts in the merge/delete progress as in other places
- Free & Pro: Data diff - 'Copy all' database progress actions appearing on merge/delete completion
- Free & Pro: Fix 'Full screen' toggle state if changed by F11
- Free & Pro: Fix 'It is an expired trial key' key entry error presentation
- Pro: Settings - new 'Local temp folder' configuration on the Misc tab
- Pro: Custom data diff - fix broken paging on setting up sort order for more than one key
- Pro: Custom data diff - deny sorting on more than one non-key column (not supported)
- Pro: Custom data diff - minor layout adjustments
- Pro: Data diff - on merge/delete, fix ignored enabled 'merge all pages' setting if both 'no backup' and 'merge all pages' confirmations are disabled
- Pro: Batch data merge/delete progress - save detailed log to the temporary file for better performance
- Pro: Batch data diff - do not close merge/delete progress on completion (same as in data diff)
- Pro: Fix cases of broken Ctrl+C in the new text viewer/editor (Query result diff, etc.)
New in AccdbMerge 1.28.0 (Feb 14, 2024)
- Free & Pro: Initial syntax highlight in the Text diff, Object list text preview and Query result diff
- Free & Pro: Ability to switch to the full screen, with F11 shortcut
- Free & Pro: Home tab - 'Copy all' database progress actions appearing in case of errors
- Pro: Batch data merge dialog - minor label and layout fixes, Alt hotkeys
New in AccdbMerge 1.27.2 (Dec 19, 2023)
- Free & Pro: Home tab - fix truncation of long file paths in the recent database list
- Pro: Home tab - indicate that recent database requires password entry (was opened by password without saved password)
- Pro: Opening db with save password if other side loaded and has no saved saved password - fix invalid save password for both (and the same for unsaved password)
- Pro: Recent database open if only the right side has no saved password - fix focus on password in the opened dialog
- Pro: Settings dialog - backup on merge/delete objects settings on the Misc. tab, ability to disable backup or making zips
- Pro: Settings dialog - replace obsolete 'Project tab' with 'Home tab' in some labels
New in AccdbMerge 1.27.1 (Nov 13, 2023)
- Pro: Home tab - fix cases of 'different protection types' unexpected error on 'open both' from recent list
- Pro: Disable parallel opening for mdw-protected vs non-protected database pair (non-protected could fail with 'cast to ApplicationClass' error), update corresponding comments on the Settings dialog
- Pro: Open protected files dialog - specify security type and mdw per side
- Pro: Open protected files dialog - remove 'Has VBA password' checkbox - it's not necessary to specify password, text boxes are enough
- Pro: Unsaved password prompt on opening recent item - fix focus on password control if 'Display passwords' is enabled
- Pro: Remember recent pair as 'use the same..' if it has same security type, mdw, user and all passwords (previously it was checking user and passwords only)
- Pro: Query key fields dialog - restore broken 'Save to diff profile' option
- Pro: Batch data diff - fix invalid 'Change columns' = No for the case of new column(s) in the left DB without other changes
New in AccdbMerge 1.27.0 (Aug 31, 2023)
- Free & Pro: Initial support for data macros (as part of table definitions, merge/delete as a whole list)
- Free & Pro: Fix occasional 'Cannot set Owner property to a Window that has not been shown previously' unexpected error for basic dialogs
- Free & Pro: Improved logic of changes invalidation after objects merge and refresh
- Free & Pro: Fix app crash on unknown error during dialog open
- Free & Pro: Instance id unification with the rest of KS DB Merge Tools
- Pro: Support for import/export specifications
- Pro: Support for All-in-one license
- Pro: Home tab - Add 'Show in folder' for recent database items
- Pro: Fix 'You entered an expression that has an invalid reference to the property Visible' on opening accde from non-trusted location
- Pro: Compare tables with indexes by default (existing users will keep current option value)
- Pro: Fix 'Cannot call StartAt' unknown error on Batch data diff -> click on view name -> compare data
- Pro: Fix and encrypt command line passwords on opening database in the new app instance
- Pro: Relations - minor text preview adjustments to unify with table definitions changes for data macros
- Free: Do not load USysRibbons table definition
New in AccdbMerge 1.26.0 (Jul 4, 2023)
- Free & Pro: Update code sign certificate (may cause smart screen warnings)
- Free & Pro: Home tab, database open - 'Close both' progress action (useful if both progresses have errors)
- Free & Pro: Data diff tab - show italic NULL text for NULLs in columns with 'visual match' mapping (which have a gray background color, was just nothing before)
- Pro: Batch data diff, merge new and changed - add option to delete target records missing in source
- Pro: Batch data diff - populate startup data in the background and fix occasional DispatcherUnhandledException unexpected error for large lists
- Pro: Object list - show selected count only if something selected
- Free: Allow to drop and merge new only table definitions, mark them as MERGE NEW ONLY on the Home tab and update tooltip text for that mark
- Free: Data diff - show total counts in the top panel
- Free: Object list - show counts in the top panel
- Free: Text diff - show counts in the top panel
- Free: Data merge/delete 'all page records selected' confirmation warning - add clarification that other pages are not going to be processed
New in AccdbMerge 1.25.1 (Apr 1, 2023)
- Free & Pro: Handle settings reading error on app start
- Free & Pro: Unknown error dialog - minor label adjustments
- Free & Pro: Updated 'repair Office' database open failure error
- Pro: Fix potential diff side swap when using mdw and one of processed DBs keeps running as lost Access process
- Pro: Fix cases of non-applied vba password
- Pro: Open protected files dialog - tab order fixes and minor layout adjustments
- Pro: Open protected files dialog - 'Save passwords' option
- Pro: Open protected files dialog - 'Encrypt passwords' option for *.acdms files
- Pro: Don't use parallel loading if same file opened for both sides
- Pro: Don't use parallel loading for files with database and/or vba password (but still can be applied for mdw-protected files)
- Pro: What's new - 'license key is not valid for this update' notice
- Pro: Custom data diff - fix unknown error on specifying the same column twice (as left without pair vs right without pair)
- Pro: Home tab - make 'Run in Access' available for mdw-protected files (opens with link to specified workgroup but without login)
- Pro: Settings - update comments for background processing
- Pro: Query result diff - add result error tooltip showing the whole error text (useful if error is truncated)
New in AccdbMerge 1.24.3 (Jan 13, 2023)
- Free & Pro: Msi - allow per-user installation, without UAC confirmation and Administrator privileges (upgrade from per-machine to per-user still requires Administrator privileges to uninstall previous per-machine version)
- Free & Pro: Msi - change images to application icon
- Free & Pro: Fix merge action shortcut tooltips (mixed up left/right active grid)
- Free & Pro: Object list - don't re-create unchanged objects on merge
- Free & Pro: Object list - allow merge only if there are any new or changed item (deny if all items are unchanged)
- Pro: Msi - remove KEYLOCATION parameter
- Pro: Object list - DL (foreign key dependency level) column for tables with configurable visibility
- Pro: Batch data diff - DL columns (foreign key dependency level)
- Pro: Custom data diff - allow window resize/minimize/maximize
New in AccdbMerge 1.24.2 (Dec 21, 2022)
- Free & Pro: Data diff and merge - better handling of the most typical failures (db open, query creation and recordset open)
- Free & Pro: Data diff - special handling of 0x800A0BF5 'Too few parameters. Expected N.' error with advise to refresh object definitions
- Free & Pro: Data diff - fix sorting in the right panel on columns having case-sensitive changes
- Free & Pro: Object list - fix swapped progress panels on Refresh
- Pro: Table structure diff - show Precision and Scale for decimals, if provided by Access (however decimal fields are still not mergeable due to the lack of DAO support)
New in AccdbMerge 1.24.1 (Dec 8, 2022)
- Free & Pro: Data diff - case-insensitive primary key column match
- Pro: Fix 'Sequence contains no matching element' on table import with data
- Pro: On existing table import remove target table relations (otherwise table is not deleted), add corresponding statement to the confirmation dialog
- Pro: Table structure diff - Update scroll background and reset selection (and bottom row) after merge/delete
- Pro: Table structure diff - Case-insensitive match by name
- Pro: Batch data diff - Select row with single click (like in object list and data diff, instead of double)
- Pro: Batch data diff - Fix calculation of Total+New for the case of Common key = No (was SQL error before)
- Pro: Handle copy to clipboard error (clipboard can be busy with some other app, https://stackoverflow.com/a/68857/282694)
New in AccdbMerge 1.24.0 (Nov 30, 2022)
- Free & Pro: Update hyperlinks, grids, text, selection look & feel
- Free & Pro: Object list - object name hyperlink tooltips
- Free & Pro: Data diff - add 'Page'/'Paging' label
- Free & Pro: Toolbar online help button
- Pro: Scroll background changes indication - more pale colors, fixed Changed indication in the object list
- Pro: Query key fields and Custom data diff dialogs - case-insensitive column match
- Pro: Data diff, Excel export - output signed and unsigned byte-sized numbers as numbers, not as text
- Pro: Settings - Database open/reload label adjustments
- Free: Data diff paging and page merge confirmation
- Free: Data diff - remove limitation on number of columns and key definition
- Free: Home tab - allow show new/all/changed
New in AccdbMerge 1.23.2 (Nov 8, 2022)
- Free & Pro: New app icon
- Free & Pro: Database open - ignore temp file cleanup failure (was 'Unknown error' before)
- Free & Pro: Data diff - fix rare occasional ArgumentOutOfRangeException on open (was 'Unknown error' before)
- Free & Pro: Unknown error dialog - add 'recommended' for option 'Send error report and close'
- Free & Pro: Improve action logs for 'Unknown error' reports (merge/delete actions, table structure diff item selection)
New in AccdbMerge 1.23.1 (Aug 8, 2022)
- Free & Pro: Read DB objects in UI thread by default to provide more stable communication with Access (like it was in v 1.20.x and lower)
- Free & Pro: Database loading - reduce object reference errors in case if Access fails to return some objects
- Pro: Settings - new option 'Background processing of database loading'
New in AccdbMerge 1.23.0 (Jul 1, 2022)
- Free & Pro: Show database open progress errors on the fly instead of accumulation
- Free & Pro: License Info dialog - after trial/full key submission keep app in the pure Free mode until restart (previously some Pro features could become partially available and cause some errors)
- Pro: Home tab - add 'Diff profiles' section
- Pro: New tab - Diff profile editor, opened by click on loaded diff profile status on the Home tab
- Pro: Custom data diff - add 'Save to diff profile' option
- Pro: Query key columns dialog - add 'Save to diff profile' option
- Pro: Query result diff - 'Save to diff profile' option
- Pro: Batch data diff - calculate new/changed counts for views with keys defined in the diff profile
- Pro: Batch data diff - 'Common primary key' renamed to 'Common key' and now includes keys defined in the diff profile
- Pro: Custom data diff - minor label adjustments
- Pro: Batch data diff - optimize "new only" calculation
- Free: Allow to compare multivalue, attachment and binary fields
New in AccdbMerge 1.22.3 (Apr 17, 2022)
- Free & Pro: Unknown error dialog - 'Close' renamed to 'Close w/o report', added 'Close app'
- Free & Pro: Find tab - Find button moved to the left and F5 shortcut added (similar to Batch and Query data diffs)
- Pro: Batch data diff - add Error column to show calculation error if any (in addition to execution progress panel)
- Pro: Object list - Relations - grayed out row selection replaced with merge/delete deny reason tooltip
- Pro: Table structure diff - cases of grayed out row selection are replaced with merge/delete deny reason tooltip
- Pro: Object list - show object boolean properties as Yes/No instead of checkbox, to unify with the rest of UI
- Pro: Data diff - reset selected count on page change
- Pro: Find tab - Handle regex parsing error without Unknown error dialog
- Free: Object list - 'Compare two selected items' hidden for tables
New in AccdbMerge 1.22.1 (Mar 4, 2022)
- Free & Pro: Add ThirdPartyNotices.txt file to the installation folder
- Pro: Generate xlsx reports without use of Excel, improve report generation performance
- Pro: Settings - Appearance tab renamed to Misc, added new options for ambiguous object names and reports
- Pro: Custom data diff - show mapping type and sorting as radio-button to change them in single click
New in AccdbMerge 1.22.0 (Feb 22, 2022)
- Free & Pro: Home/Project tab redesign
- Free & Pro: Home/Project tab - Close other tabs, updated Close icon for other tabs
- Free & Pro: Home/Project tab - Show DIFF ONLY marks for Table definitions in Free and References in Pro
- Free & Pro: Header panel redesign for Find tab, Batch data diff and Query result diff tabs
- Free & Pro: Handle 'The expression you entered refers to an object that is closed or doesn't exist' error properly during DB loading
- Free & Pro: 'Warn about Access windows' dialog updated (both text and image)
- Free & Pro: Text diff - fix occasionally missing underscore on some display settings
- Pro: Home/Project tab - new 'Show in folder' action
- Pro: Query result diff - set default to No mapping
- Pro: Query result diff - fix text diff defaults (were not taken from Settings)
- Pro: Custom data diff - change 'project' -> 'database'
- Pro: Data diff - remove old logic on using unique indexes by default if there is no compatible primary key (it was invalid for Required=No fields, and this change made table definitions loading faster)
- Pro: Batch data diff - replace Common Key and Primary Key columns with single Common primary key
- Pro: Batch data diff - object name click - open Table structure diff for tables, indented Text diff for queries
- Pro: Batch data diff - jump next/prev change - scroll grid if to make row visible if necessary
- Pro: Object list - add 'Open in Query result diff' action for table definitions and views
- Pro: Table structure diff - add 'Open in Query result diff' action
- Free: Limit number of opened Find tabs
New in AccdbMerge 1.21.0 (Feb 10, 2022)
- Free & Pro: Table structure diff - new UI with collapsible groups, bottom grid for selected row (Pro) and common scrollbar with changes highlight (Pro)
- Free & Pro: Table structure diff - highlight in yellow 'moved' fields (with changed order)
- Free & Pro: Table structure diff - unify presentation of boolean flags as Yes/No (earier it could be also True/False or checkbox)
- Free & Pro: Table structure diff - show properly type Data/Time Extended (as dbDateExtended instead of 26)
- Free & Pro: Improve performance of DB loading: background processing, load two files in parallel (from toolbar or from recent list)
- Free & Pro: File open progress - add one more 'Calculating changes..' step
- Free & Pro: Improve Access non-availability handling
- Free & Pro: Project tab - align Recent list, truncate long paths
- Free & Pro: Project tab - truncate long file name
- Free & Pro: Object lists - highlight Created/Modified dates of changed objects as yellow (color of ignored change) instead of red to indicate that date is not the reason of considering object as changed
- Free & Pro: Data diff - improved error handling of corrupted/unavailable data
- Pro: Table structure diff - changed presentation of 'Linked table' section
- Pro: Table structure diff - 'Hide empty field properties' option
- Pro: Table structure diff - recognize more values for DisplayControl property (like "Check box")
- Pro: Table structure diff - field merge failure - include last processed property name
- Pro: Table structure diff - Explicitely deny merge field of non-supported data types: Number Decimal (dbDecimal, previously it was producing invalid merge result) and Date/Time Extended (dbDateExtended, previously it was just failing)
- Pro: Table structure diff - Split relations to Parent and Child relations
- Pro: Table structure diff - Excel export: include linked table data, split relations to Parent and Child relations
- Pro: Table structure diff - allow batch selection
- Pro: Fix 'Object invalid or no longer set' error on merging more than one index
- Pro: Fix 'Object invalid or no longer set' error on merging more than one relation
- Pro: Project tab - new 'run in Access' action
- Pro: Relations (Object list and Table structure diff) - added Join property (INNER/LEFT/RIGHT)
- Free: Table structure diff - add 'Linked table' section
New in AccdbMerge 1.20.1 (Dec 23, 2021)
- Free & Pro: Activation dialog - allow to configure 'check for updates', updated some information
- Free & Pro: Project tab - change 'reload' label to 'refresh' and run action without closing other tabs
- Pro: Data diff - fix reversed order in 'copy to clipboard' result
- Pro: Object list text diff preview - fix disappearing scrollbar issue
New in AccdbMerge 1.20.0 (Nov 26, 2021)
- Free & Pro: Check for updates
- Free & Pro: Add Refresh action applicable for Project, Object list and Data diff tabs
- Free & Pro: Text diff - 'Ignore empty line' option
- Free & Pro: Error handling - fix invalid COM error on missing file
- Free & Pro: Error handling - recognize DB open failure caused by Access configured to run 'As Administrator'
- Free & Pro: Progress panel - highlight some processing errors in red and fix some issues with progress close on error
- Free & Pro: Fix some warnings about highest supported Access version
- Free & Pro: Replace '[email protected]' with '[email protected]' in app and on the web site
- Pro: Object list, Copy to clipboard - add column headers, remove selection column
- Pro: Data diff, Copy to clipboard - add column headers, remove selection column
- Pro: Query result diff, Copy to clipboard - add column headers, remove selection column
- Pro: Project tab - support 'Copy to clipboard'
- Pro: Text diff - 'Ignore empty line' setting
New in AccdbMerge 1.19.0 (Jul 28, 2021)
- Free & Pro: Tab toolbar actions moved inside tab, into the panel splitter
- Free & Pro: Project tab - Tables renamed to Table definitions
- Free & Pro: Changed Table definitions icon
- Free & Pro: Enable legacyUnhandledExceptionPolicy to avoid crash after background thread error
- Free & Pro: Fix unknown error on opening invalid *.acdms file
- Free & Pro: Handle open help page failure
- Free & Pro: More usage of system control background color
- Free & Pro: Improve settings stability by using read/write retry attempts
- Free & Pro: Fix some cases of NullReferenceException on single project open in Project tab and single right project loaded object list
- Pro: Project tab - Show all/new/changed actions supported
- Pro: Text diff - Fix loading from command line
- Pro: Text diff - Fix NullReferenceException on view/query compare data
New in AccdbMerge 1.18.7 (May 21, 2021)
- Free & Pro: Updated instanceId algorithm to reduce collisions on trial registrations
New in AccdbMerge 1.18.6 (May 18, 2021)
- Free & Pro: 'Compare selected' option made available for Tables
- Free & Pro: Object list - allow selection of tables and references
New in AccdbMerge 1.18.5 (Apr 20, 2021)
- Free & Pro: Toolbar - showing tooltips on disabled buttons, with disable reason
- Free & Pro: Make deletion shortcut as Ctrl+D as mentioned by tooltip and help page
- Free & Pro: Object list - improve performance of show all/new/changed for large object lists
- Free & Pro: Object list - improve performance of batch selection for large object lists
- Free & Pro: Improve performance of database loading (final 'compare' stage)
- Free & Pro: Increase row heights of some grids (to be the same as for data diff)
- Pro: Table structure diff - hide 'compare data' actions if table exist only on one side (was causing unknown error)
New in AccdbMerge 1.18.4 (Mar 16, 2021)
- Free & Pro: DB engine error dialog simplified
- Free & Pro: Object list - fix unknown error on Ctrl+R shortcut
- Free & Pro: Database loading - suggest to check AccdbMerge & Access 32/64 bitness in case of 0x80029c4a error
- Pro: Text diff - 'Ignore form/layout version and checksum' renamed to 'Ignore form/layout noise and now also excludes NoSaveCTIWhenDisabled which can be multiplied
- Pro: Batch Data Diff - fix N/A Total for Total only calculation if 'Generate report' checked
- Pro: Batch Data Diff - control options and labels simplified
- Free: Data diff - fix truncation to 1000 rows on the first app run
New in AccdbMerge 1.18.3 (Mar 10, 2021)
- Free & Pro: Project tab - fix some cases of missing Changed and New+Changed counts for adp files
- Free & Pro: Project tab - fix some cases of missing Changed and New+Changed count resets on loading mde/accde/ade after mdb/accdb/adp
New in AccdbMerge 1.14.4 (May 20, 2019)
- Pro: Diff overview in scrollbar (for object list, data diff, text diff, batch data diff, query result diff, field list in table structure diff)
- Pro: Batch data diff - fix some jump prev/next issues related to sorting
New in AccdbMerge 1.14.3 (Mar 24, 2019)
- Pro: Batch data diff column sorting
- Free: remember 'Don't ask me again' for project reload dialog
- Free & Pro: DBE dialog minor updates
New in AccdbMerge 1.14.2 (Mar 19, 2019)
- Free & Pro: Exclude DBE 2010 from installation, provide more 2010 & 2016 download links
- Free & Pro: Data diff, Query result diff - better Access app dispose in 'Use DB engine from Access' mode
- Free & Pro: Project tab - 'reload' action
- Free & Pro: Project reload warning and options
- Free & Pro: Zoom button splinted into separate zoom in / zoom out buttons
- Free & Pro: Initial license window keyboard navigation improvements, updated Help text
- Free & Pro: Improved processing of unexpected failures
- Free & Pro: MSI: updated product name with default installation path (removed 'Pro'), updated website URL
- Pro: Command like - more password-protected arguments
New in AccdbMerge 1.14.1 (Jan 15, 2019)
- Pro: Batch data diff - report generation and access keys
- Pro: Query result diff - access keys
- Pro: 'Custom data diff' and 'Query key fields' dialogs - fix 'not unique' error message, it was showing 'left' both for left and right sides
New in AccdbMerge 1.14.0 (Oct 25, 2018)
- Free & Pro: Use Access application DB engine if no other available
- Free & Pro: 'Replace' and 'Compare selected' actions in object list (with limitations for tables, relations and references)
- Free & Pro: Project tab - use grid to show and highlight counts
- Free & Pro: Update accessibility warning with 2019 max version
New in AccdbMerge 1.12.2 (Oct 15, 2018)
- Pro: Quick filter (Alt+F) for Object List and Batch Data Diff
New in AccdbMerge 1.12.1 (Oct 12, 2018)
- Free & Pro: Data diff - 'Case insensitive' and 'Ignore whitespace' string compare options
- Pro: Field properties - removed Description added most of general (UnicodeCompression, IMEMode, IMESentenceMode, TextFormat, TextAlign, AppendOnly, ShowDatePicker) and all lookup (DisplayControl, RowSourceType, RowSource, BoundColumn, ColumnCount, ColumnHeads, ColumnWidths, ListRows, ListWidth, LimitToList, AllowMultipleValues, AllowValueListEdits, ListItemsEditForm, ShowOnlyRowSourceValues) properties
- Free & Pro: Table structure diff - freeze Name columns
- Pro: Query result diff - fixed broken query execution after fixed SQL error
- Pro: Show field properties if only one project loaded
- Pro: Table structure diff - fixed possible false diff detection in case of 'Compare field properties' option
- Pro: Query result diff - disable show new/changed and selection actions if there is no result
- Free & Pro: Data diff - fix error on record selection column click
- Free & Pro: minor progress frame appearance improvements
New in AccdbMerge 1.12.0 (Aug 2, 2018)
- Free & Pro: Main window zoom
- Free & Pro: Show all dialogs centered by main application window
- Pro: Settings -> Table Structure Diff: "Compare indexes" option
- Pro: Consider index as changed if it has changed Primary/Unique/IgnoreNulls flags (earlier it was taking into account only index fields)
New in AccdbMerge 1.11.12 (Jun 28, 2018)
- Free&Pro: Text diff - show line numbers
- Pro: Text diff - sync horizontal scroll in bottom panel
- Pro: Object list - allow to indent SQL queries by default
- Pro: Fix "object invalid or no longer set" error on tables loading for some mdw-protected files
New in AccdbMerge 1.11.11 (May 11, 2018)
- Free&Pro: Fix copy to clipboard error (CLIPBRD_E_CANT_OPEN)
New in AccdbMerge 1.11.10 (Jan 24, 2018)
- Free&Pro: First run check for Access and Database Engine availability, suggestion to install Database Engine
- Free&Pro: Object list - adjust Name column width to take more available space
- Pro: Project tab - drilldown to batch data
New in AccdbMerge 1.11.9 (Nov 1, 2017)
- Free&Pro: Fix "Could not load file or assembly 'Microsoft.Office.Interop.Access.Dao'" error (was happened at least in some cases of Office 365)
- Free&Pro: Check DB Engine availability during file open
- Pro: Improve "Load field properties" performance
New in AccdbMerge 1.11.8 (Sep 27, 2017)
- Free&Pro: Fix few "Ignore all whitespaces" bugs (button state, settings saving, combination with leading/trailing whitespace option)
New in AccdbMerge 1.11.7 (Sep 26, 2017)
- Free&Pro: "Ignore all whitespaces" text compare option
- Pro: "Compare field properties" table structure diff setting
New in AccdbMerge 1.11.6 (May 9, 2017)
- Free&Pro: Fix some cases of mdb form/report/module diff failure
New in AccdbMerge 1.11.5 (Mar 6, 2017)
- Free&Pro: Fix "object reference not set" errors on drilldown to text diff from Find and from Object list
- Free&Pro: Hide "new+changed" for compiled objects (it is not valid since "changed" is not calculated)
- Pro: Basic adp/ade files support
- Pro: deny try to merge/delete if any side can not be changed (for example for compiled modules)
New in AccdbMerge 1.11.4 (Nov 1, 2016)
- Pro: 'Ignore binary content' forms & reports text diff option
- Pro: 'Ignore version and checksum' forms & reports text diff option
New in AccdbMerge 1.11.3 (Jun 7, 2016)
- Free&Pro: objects merge/delete performance improvements (load only new objects after import, don't reload all after delete)
- Free&Pro: allow to close hanged progress popup in case of unexpected errors
- Pro: keep dbAttachSavePWD table attributes during table import
New in AccdbMerge 1.11.2 (May 21, 2016)
- Pro: Import tables with data
New in AccdbMerge 1.11.1 (May 18, 2016)
- Free&Pro: remember last path of left/right file open dialog
- Free&Pro: update only affected object types after objects import/delete
- Free&Pro: objects import/delete progress
- Pro: Default 'Ignore whitespace' settings
New in AccdbMerge 1.11.0 (Feb 10, 2016)
- Free&Pro: Project tab - added 'new+changed' count
- Free&Pro: freeze row selection column
- Pro: RegEx search
- Pro: Excel export - using text format for text data, preventing Excel to reformat data
New in AccdbMerge 1.10.8 (Feb 4, 2016)
- Free&Pro: data diff - updated merge&delete confirmation dialog
- Pro: data diff - ability to merge&delete all pages
- Pro: data diff - ability to adjust field mapping in data diff
New in AccdbMerge 1.10.7 (Dec 10, 2015)
- Pro: Custom data diff - ability to merge (if target recordset allows)
New in AccdbMerge 1.10.6 (Nov 24, 2015)
- Free&Pro: data diff - treat dbText and dbMemo as comparable data types
- Pro: Query Result Diff - initialize right query text with left one on 'split query'
New in AccdbMerge 1.10.5 (Nov 7, 2015)
- Free&Pro: more user-friendly DB engine / Microsoft Access communication errors
New in AccdbMerge 1.10.4 (Nov 7, 2015)
- Free&Pro: fixed numbers comparison when sides have different numeric data types
New in AccdbMerge 1.10.3 (Sep 24, 2015)
- Free&Pro: Microsoft Access 2016 support
New in AccdbMerge 1.10.2 (Jul 27, 2015)
- Pro: Updated data retrieval technique, removed dependency on ACE OLE DB provider (this could fix some issues in batch data diff, custom data diff and query data diff)
- Pro: improved query key fields dialog usability (focus on the list and select first item by default)
- Free: ability to get a Pro trial
New in AccdbMerge 1.10.1 (May 26, 2015)
- Free&Pro: Added keyboard shortcuts for multiple actions
- Free&Pro: Data diff - first data merge confirmation
- Free: removed data diff, merge and delete limitations related to number of key fields and their data type
- Free: introduced single-instance Find tab
New in AccdbMerge 1.10.0 (Apr 22, 2015)
- Pro: 'Query result diff' tool
- Pro: Query data diff - updatable query now can be a target of the merge/delete action
- Pro: Query data diff - paging
- Pro: Custom data diff - paging
- Pro: Batch data diff - F5 shortcut for 'Run' action
- Pro: Next/Previous change shortcuts (Alt+Down and Alt+Up respectively)
New in AccdbMerge 1.9.7 (Mar 23, 2015)
- Pro: fix 'Cannot open any more tables' custom data diff error
New in AccdbMerge 1.9.6 (Mar 2, 2015)
- Free & Pro: records and objects deletion (for only those records/objects which can be selected, selectability logic was not updated and based on ability to merge)
- Free & Pro: close dialogs on Esc
- Free & Pro: minor file open progress improvements
- Pro: Custom data diff - remove on-click focus&editing (was not convenient for scrolling after click on dropdown columns)
- Pro: Batch data diff export to excel - fixed broken column labels
New in AccdbMerge 1.9.5 (Feb 20, 2015)
- Pro: fixed 'No current record' error for some multivalue and attachment data comparison cases
New in AccdbMerge 1.9.4 (Feb 20, 2015)
- Pro: fixed 'Offset and length were out of bounds' in the custom data diff during scroll of the big mappings list
New in AccdbMerge 1.9.3 (Feb 20, 2015)
- Pro & Free: allow data diff for read-only files
- Pro & Free: improved data merge error handling
New in AccdbMerge 1.9.2 (Feb 20, 2015)
- Pro & Free: improved file open error handling and stability
- Free: 'Submit full license key' in 'About license' window
New in AccdbMerge 1.9.1 (Feb 20, 2015)
- Free: Object list - fixed UI layout issue in the left panel
- Pro: Custom data diff - minor UI adjustments
New in AccdbMerge 1.9.0 (Feb 20, 2015)
- Pro & Free: fix error "'System.Windows.Documents.Run' is not a Visual or Visual3D"
- Pro: Custom data diff - compare any tables and query with ability to specify custom field mapping
New in AccdbMerge 1.8.1 (Feb 20, 2015)
- Pro & Free: select row on click outside of table columns for table structure diff
- Pro: select row on click outside of table columns for batch data diff
- Pro: move previous/next change in the object list, table structure diff and batch data diff
- Pro: show all/new/changed in the batch data diff
New in AccdbMerge 1.8.0 (Feb 20, 2015)
- Pro & Free: common binary package
- Pro & Free: for narrow tables - select row on click outside of table columns
- Pro & Free: fixed selection gray out for tables and references
- Pro: simplified trial/puchased license activation UI
- Free: installation package (not portable anymore)
- Free: removed header panel in object list and data diff
- Free: improved SQL indent, indent SQL button
- Free: file open progress
- Free: text diff, data diff and object list - synchronise row selection
- Free: performance improvements
New in AccdbMerge 1.7.9 (Feb 20, 2015)
- Fixed "Cannot open any more tables" data merge error
New in AccdbMerge 1.7.8 (Feb 20, 2015)
- Compression of form and report definitions ("Enable compression" option on the "Text Diff" settings tab)
- Report "out of memory" forms & reports loading errors
- Text diff view memory usage and performance improvements
- Object list memory usage and performance improvements
- Wrap text in the progress window
New in AccdbMerge 0.5.8 (Mar 21, 2014)
- text diff view - fixed underscore ('_') visibility
- fixed object lists sorting
New in AccdbMerge 0.5.7 (Nov 5, 2013)
- fixed "Input string was not in a correct format" error on file open
New in AccdbMerge 0.5.6 (Oct 11, 2013)
- object list - case insensitive object name comparison
New in AccdbMerge 0.5.5 (Oct 11, 2013)
- updated data diff algorythm: fixed data types compatibility issues, improved performance, introduced limitation for a number of fields
- digital signature added
- fixed broken column width synchronisation in data diff
- more stable handling of database locks during project load and object import
- updated color scheme for object list, like in Pro
New in AccdbMerge 0.5.4 (Oct 11, 2013)
- object list - displaying icons for additional actions instead of text
- table diff view - removed clipboard support since it was not working properly for some cases
New in AccdbMerge 0.5.3 (Jan 9, 2013)
- fixed a bug when corrupted query was preventing the file loading process
New in AccdbMerge 0.5.2 (Oct 4, 2012)
- changed text comparison algorithm, as a result some text comparison issues has been fixed
- ignore case/whitespace text comparison options
- fixed null reference error on new queries/forms/reports drilldown
- data diff for tables with multivalue/attachement fields made possible for Access 2007 installations (earlier there was an error), however the content of such fields is not being compared and displayed as N/A
- project tab UI adjustments - columns alignment and sorting object types in Access-native way (1. tables, 2. queries, etc.)
- handle unavailable linked tables errors
- omit hidden queries
- fixed module/layout switching bug
New in AccdbMerge 0.5.1 (Sep 5, 2012)
- object list made similar to data diff window, making easier to observe new/missed/changed objects
- show all, new, changed, new&changed objects and records
- "compare data" drilldown with "only new or changed" option
- compare module/layout separately for forms and reports
- allow multiple "find" tabs
- selection buttons moved to toolbar
- fixed tab navigation for already opened tabs
- fixed toolbar synchronization with current selection
New in AccdbMerge 0.4.2 (Sep 5, 2012)
- compare indented query text
New in AccdbMerge 0.4.1 (May 7, 2012)
- table data merge
- "find" tab
New in AccdbMerge 0.3.5 (Mar 21, 2012)
- performance improvements related to table diff (now it is being opened faster and larger tables can be loaded)
New in AccdbMerge 0.3.4 (Mar 21, 2012)
- fixed "The value '0' is not a valid value for the enum ' '" error in object compare window
- fixed localization issue when object text did contain non-english characters (processing this text with current system ANSI code page)
- updated error handling for cases when some objects cannot be read due to MS Access protection or some other reason
New in AccdbMerge 0.3.3 (Mar 13, 2012)
- performance improvements related to tab switching
New in AccdbMerge 0.3.2 (Mar 13, 2012)
- table diff - highlighting missed columns
New in AccdbMerge 0.3.1 (Mar 13, 2012)
- initial version of table diff
New in AccdbMerge 0.2.2 (Mar 13, 2012)
- open database files with Shift key pressed in order to bypass startup code/macros
New in AccdbMerge 0.2.1 (Mar 13, 2012)
- mdb files support
- changed layout of object list (date formats)
- grayscale disabled merge buttons
- initial presentation of table structure (field name, DAO field type, field size)
- deny tables merge (because it can affect existing relationships)
- fixed bug related to replacement of existing object