Choosing drivers for Microsoft Access compatibility
The import of Microsoft Access (.accdb) file data into Micromine Origin & Beyond may require suitable drivers to be installed. Which is the most appropriate way to install the Access drivers will depend on your current setup.
The most recent versions of Microsoft Office include the necessary drivers and do not require you to install any additional drivers. However, if you are using an older version of Office or Office 365, you may need to manually install the Microsoft Access driver.
The correct driver to install will depend on which version of Office is installed. When choosing drivers for Microsoft Access compatibility, it is recommended you follow the guidelines set out by Microsoft:
| Current Office Installation | Additional components needed | Recommended Additional Installation |
|---|---|---|
| Microsoft 365 Apps for Enterprise, Office 2016/2019/2021 Consumer Version 2009 or later | No | - |
| Microsoft 365 Apps for Enterprise, Office 2016/2019 Consumer Prior to Version 2009 | Yes | Microsoft Access 2013 Runtime |
| Office LTSC 2021 (Volume License) | No | - |
| Office 2016/2019 Pro Plus C2R (Volume License) | Yes | Microsoft Access 2013 Runtime |
| Office 2010/2013/2016 MSI | No | - |
| No Office installation | Yes | Microsoft 365 Access Runtime |
Note:
-
The Microsoft Access Database Engine 2016 Redistributable is not provided as a recommended solution for the indicated scenarios as both the Access Database Engine 2016 and M365 Apps use the same major version identifier (16.0) which may introduce unexpected behaviors. Office side-by-side detection will also prevent the installation from proceeding if this scenario is detected.
-
The Microsoft Access Database Engine 2010 Redistributable, while suitable as an alternative to Microsoft 365 Access Runtime, is no longer suggested as a recommended solution because Office 2010 has reached the end of the Microsoft Support Lifecycle.
For further information visit:
Caution: Be careful: as per the notes above, installing the wrong Access driver may clash with the Microsoft Office installation, corrupting either the Office installation or the Access driver; this may also cause Micromine Origin & Beyond to crash when trying to use the Access driver to import data.