Known Issues
Microsoft Access XP/2003 support
AccdbMerge uses Microsoft Access COM object to handle database files. It was designed to use Microsoft Access 2007 references, so it should work properly with Access 2007/2010/2013, but Access XP/2003 support is not guaranteed.
Other common issues
- error message "The database you are trying to open requires a newer version of Microsoft Access" in the data diff. Your database is using BigInt columns which are not supported by Access Database Engine. See:
Assuming that you're able to observe such tables in Access, the suggested workaround is to enable "Use DB Engine from Access application" option in toolbar - this will cause to use Access to read data. This will be much slower but should work.
- error message "Failed to load some objects from file <file name>: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))" during file open. This means that MS Access is either not installed or it is not registered properly in Windows. It may happen that Office components registration may be broken with Windows or other software updates. The solution can be found at https://support.microsoft.com/en-ca/kb/2019235Â
- error message with CLSID {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} or {68CCE6C0-6129-101B-AF4E-00AA003F0F07} on file open - this means that AccdbMerge can not connect to Microsoft Access. Please be sure that you have full Microsoft Access installed, not Access Runtime. Also, if you have configured Microsoft Access to run 'As Administrator' - you have to do the same for AccdbMerge. Otherwise you will get this error. Sometimes it may happen that Microsoft Access components registration is broken, this can be fixed with Microsoft Office installation repair.
- "Microsoft Office Access Security Notice" and MS Access window appears when user open some file or merges some objects.To fix this you have to enable macros in MS Access security options or add your file to trusted location. The main rule is that when you open your file in Access it should not show any dialogs, warnings, etc. AccdbMerge uses MS Access to open and read files, and if MS Access shows some dialogs on opening file, then AccdbMerge can not take responsibility for those dialogs and they require user interaction.
- selection checkboxes are available in Tables list, but they are not operable (table merge currently is not supported due to relationships)
- data cells in data diff view can be edited, but these changes are not synched with underlying database. Actually, these cells should be locked for edit