Knowledge Base - Technical Articles
HowTo: Connect to Microsoft Access 2007/2010 (ACCDB) files in ArcGIS
|Software:||ArcGIS - ArcEditor 9.2, 9.3, 9.3.1, 10 ArcGIS - ArcInfo 9.2, 9.3, 9.3.1, 10 ArcGIS - ArcView 9.2, 9.3, 9.3.1, 10 ArcGIS for Desktop Advanced 10.1 ArcGIS for Desktop Standard 10.1 ArcGIS for Desktop Basic 10.1|
|Platforms:||Windows 2000, XP, Server 2003, Vista, Server 2008, Windows 7, Windows 8, Server 2012|
Microsoft Access 2007/2010 databases can be read within the ArcGIS environments using an OLE DB database connection. Reading these databases requires the correct ODBC drivers to be installed.
1. To check whether the 32-bit Microsoft Access Database Engine drivers are installed, go to C:\Windows\SysWOW64\odbcad32.exe. If on a 32-bit machine, go to C:\Windows\System32\odbcad32.exe to access the utility. Go to the drivers tab. If the Microsoft Access Driver lists .mdb and .accdb, then the correct drivers are installed. In this case, skip to step 4.
2. If the Microsoft Access Driver only lists .mdb, the necessary driver is not installed. If 64-bit Office 2010 is installed, the 2007 Access Database Engine must be installed. Else, the 2010 Access Database Engine (32-bit) can be installed.
3. After installing the engine, several new drivers appear in the ODBC Data Source Manager, including drivers that are able to read .accdb files. The Microsoft Access Driver now lists .accdb as a file-type it supports.
Before and After
4. Launch the 'Add OLE DB Connection' utility in ArcCatalog. To locate this utility using ArcGIS 10 or older, see the 10.0 Web help document Adding OLE DB connections. If using ArcGIS 10.1 or newer, see the 10.1 Web help topic Adding OLE DB connections to databases.
5. In the Data Link Properties dialog box, select the Microsoft Office 12.0 Access Database Engine OLE DB Provider.
OLE DB Provider
6. Click Next to open the Connection tab.
7. For step 1, Data Source, either type or copy and paste the location to the ACCDB file.
Paste Path to Access Database
8. If required by the database, enter a password.
9. Click the Test Connection button. A message appears stating whether or not the test connection was successful.
10. Click OK in the Data Link Properties dialog box.
There is now a new OLE DB Connection in the Database Connections folder. Optionally, the new OLE DB Connection can be renamed something that relates to or identifies the database.
Connection will be under Database Connections
Double-clicking the OLEDB Connection and viewing the Contents tab displays the contents of the database. Clicking the plus sign next to the database also displays the contents.
The contents of this database can now be used in most ArcGIS dialog boxes by navigating to the Database Connections folder. Tables and queries can also be dragged and dropped from the Database Connections into ArcMap or tool dialogs.
Last Modified: 7/22/2013