Problem: Unable to access a Microsoft Access database after adding an OLE DB connection
When attempting to access a Microsoft Access database (ACCDB) after adding an OLE DB connection, the Microsoft Access table is not added to the database connection.
There are several possible reasons for this issue:
• The Microsoft Access database extension (.accdb) is not included in the name when selecting the data source.
• The machine is missing the appropriate driver needed for the Microsoft Access database or is using a different bit version. If a 32-bit database is installed, the same 32-bit driver is needed for the connection to work. The driver installation comes together with the installation of the Microsoft Access Database Engine.
Solution or Workaround
To ensure a connection is made, follow one of the suggested solutions.
- Make the connection through ArcCatalog instead of ArcMap. For more information about connecting to a Microsoft Access database in ArcGIS, refer to the following article, HowTo: Connect to Microsoft Access 2007 / 2010 (ACCDB) files in ArcGIS.
- Ensure the extension is included in the database name when selecting the data source. If the name is already specified, rename the database connection by right-clicking the database name and selecting Rename.
- Provide the necessary driver for Microsoft Access and perform a soft reset:
1. Download and install the necessary drivers for Microsoft Access. For more information, refer to the following link, Microsoft Download Center.
2. Perform a soft reset on Esri application data and Esri registry keys:
Warning: The instructions below include making changes to essential parts of your operating system. It is recommended that you backup your operating system and files, including the registry, before proceeding. Consult with a qualified computer systems professional, if necessary. Esri cannot guarantee results from incorrect modifications while following these instructions; therefore, use caution and proceed at your own risk.
- Reset the Esri application data by locating the App Data folder > Roaming > Rename all Esri folders to Esri_Old.
Note: The App Data folder is a hidden folder. Enable viewing of hidden folders for Windows Explorer to locate it.
- Reset Esri registry keys by opening the Registry Editor; search 'regedit' in the search option of the Windows Start menu. Expand HKEY_CURRENT-USER > Software > rename all Esri folders to Esri_OLD.