Unable to access a Microsoft Access database after adding an OLE DB connection

Description

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.

Cause

There are several possible reasons for this issue:
 

Solution or Workaround

• 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.