Understanding how to use Microsoft Access files in ArcGIS

You can use tables from a Microsoft Access database in ArcMap through an OLE DB connection. OLE DB is a standard for sharing data between applications, enabling you to view the Access database in ArcMap. To maintain data integrity, you should only modify an Access database in Access.

Similarly, you should only edit a personal geodatabase in ArcGIS. Although a personal geodatabase is stored as an Access .mdb, you should not open or modify the tables in a personal geodatabase inside Microsoft Access. This can corrupt the geodatabase and cause data loss.

The limitation of Microsoft Access as an application to edit personal geodatabases is that Access was not designed to use or understand the ESRI functionality behind the personal geodatabase format. For example:

Microsoft Office 2007 introduced a new Microsoft Access database format, accdb, which is the new default format in Access 2007 when saving or creating a database. Without using OLE DB, ArcGIS cannot directly read or write to the new Microsoft Access format; this includes accessing accdb files directly through the Add Data dialog box.

Related Topics


9/17/2012