Microsoft Office 2007 introduced a new Microsoft Access database format, ACCDB. When creating a database, ACCDB is the new default format in Access 2007 and Access 2010.
Note: The proper way of connecting to Microsoft Access databases, either the MDB or ACCDB formats, is through an OLE DB connection. Though it is technically possible to connect to MDB files through the Add Data dialog box in ArcMap, it is not the recommended workflow. With the new Microsoft Access format, accessing ACCDB files directly through the Add Data dialog box is not possible.
Microsoft Access 2007/2010 databases can be read within the ArcGIS environments using an OLE DB database connection. Reading these databases requires installation of the correct ODBC drivers.
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.
Note: It is not possible to install the 32-bit 2010 Microsoft Access Database Engine if 64-bit Microsoft Office 2010 is installed. This is a limitation as described in Microsoft Article 2269468. In this scenario, the 2007 Microsoft Access Database Engine can be installed. The 2007 engine can read both 2007 and 2010 Access databases for OLE DB purposes. For more information on 2007/2010 ACCDB compatibility, review the Microsoft Developer Network article: Backward compatibility between Access 2010 and Access 2007.
Before and After
Note: The Microsoft Office 12.0 Access Database Engine Provider was installed with either Microsoft Office or the Access Database Engine.
OLE DB Provider
Paste Path to Access Database
Note: The ability to browse to an ACCDB file in this dialog box is a Microsoft limitation that cannot be addressed by Esri.
Connection is listed under Database Connections
Note: There are a few limitations to be aware of when working with OLE DB connections. See the link in the Related Information section below for more information.
Note: For NIM009080, a possible workaround is to use an Microsoft Access ODBC Driver instead of the OLE DB connection.