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)
Microsoft Access Database Engine 2007 64 Bit Free Download
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.
MDB Viewer Plus has been written to provide a free, quick and easy way to open, view, edit, filter, sort, import to, export from, modify and search MDB and ACCDB files.This is useful for software developers like myself who use Access databases as a backend database for their bespoke software. MDB Viewer Plus provides a convenient way to view and edit these databases. The table info screen even has the ability to copy the list of field names in a table to the clipboard. A developer can then paste this list into their source code for direct access.
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. 2ff7e9595c
Comments