AnsweredAssumed Answered

Adding Microsoft Access table to ArcMap?

Question asked by efgrad2 on May 1, 2017
Latest reply on May 1, 2017 by RApplebaum-esristaff

I am looking to map gps coordinates from a Microsoft Access table (.mdb) in ArcMap. I successfully connected ArcMap to Microsoft Access through an OLE DB connection, and can see the Access table in both ArcCatalog and the Add Data dialog box. However, when I attempt to add the table I receive the following warning:

A selected item could not be added to the map. General Function Failure.

After searching online for a solution I thought maybe ArcMap could not read the file because of an incompatible driver. I am running Microsoft office 2016 (64-bit) on a 64-bit machine. However I read that since ArcGIS is a 32-bit program the correct driver for this setup would be Microsoft Office Access Database Engine 2007, which is the driver currently installed on my computer.

All other documentation I have found online indicates that this should be a fairly simple process, and I can not find any mention of the problem I am having. 

I'm using ArcGIS 10.4.1, and the MDB file is Access 2000 file format.

The field names in the access table are all alphanumeric, no spaces, and no reserved words are used.

Any suggestions on why this is happening?

Outcomes