ArcGIS Desktop is a 32-bit application. Because of this, it requires 32-bit ODBC drivers to make database connections. If Office 2007 or Office 2010 x86 (32-bit) is installed, the 32-bit Microsoft Access Database Engine is likely already installed. If Office 2010 x64 (64-bit) is installed (or Microsoft Office is not installed at all), the 32-bit database engine must be installed before a connection can be made to Microsoft Access databases in ArcGIS Desktop.
If you encounter the below error when trying to access the external data source in the 32-bit version, check your Windows Programs and Features to ensure that the 32-bit Access Database Engine is installed (it may not be labeled as such and could have a year of 2007, 2010 or 2016). If so, try running a Repair on it or uninstall and reinstall. If not, please download and install from Microsoft, or reinstall your OpenFlows product (as this is part of the prerequisites)
There are also cases where we have seen that the 2007 Microsoft Access database engine has been removed from the computer for some reason. This can also cause a problem because removal of the 2007 version of the Microsoft Access database engine can break the 2010 version. What you can do in order to fix this is download the 2007 Access database engine from the Microsoft website and install it manually. You also have the option to uninstall the Bentley OpenFlows product and reinstall it if that is easier for you.
If installing software that uses Microsoft Access Database Engine 2007 such as InteractX, this will cause PMM to stop working. To fix, uninstall PMM and Access Database Engine 2010 and then re-run the PMM installer. This will re-install the database engine and PMM. PMM installer includes Visual C++ redistributable and Access Database Engine and do not need to be manually installed nor downloaded. If already installed on the PC, these steps will be skipped.
To open an ACCDB file select "ACCDB files" from the drop down box on the open dialog labelled "Files of type:" then select your Accdb. Note that if you don't have Access 2007 or higher installed you will need to install the Microsoft Access 2007/2010 database engine first as a prerequisite. You can download the Access 2007 database engine from Microsoft's website.
First, I will dispense with the most obvious reason for the error, and that is that the provider hasn't been registered on the machine on which the application is running. The ACE provider is not installed on Windows operating systems by default. You have to install it. The ACE provider is available in three forms: Microsoft Office Access database engine 2007 , the Microsoft Access Database Engine 2010 Redistributable and the 2016 Distributable . The 2007 version is only available as a 32-bit component whereas the 2010 and 2016 versions offer both 32 and 64-bit options. You need to be careful which option you choose, because a wrong choice here is the most frequent cause for the error message. 2b1af7f3a8