AnsweredAssumed Answered

ArcMap & Catalog: DB connection to ACCDB file

Question asked by awa5114 on Jun 19, 2016
Latest reply on Jun 22, 2016 by rastrauch

have successfully established a database connection using ArcCatalog to an access database. I am using Access 2013 and ArcMap 10.2.2. I used as a database provider Microsoft Jet Engine version 12.0 when creating the connection in Catalog. When trying to import some of the tables into the ArcMap table of contents I get the following error message:

Warning Could not add the specified data object to the map

General function failure [Export_Table]

The Microsoft Office Access database engine cannot read the data in Export_Table

The Minimum required version to read the data it 14.0.0000.0000

Some tables (from the same database) still upload however. This is true for those which were not altered by queries or calculated fields, etc in the database. I'm suspecting this is partially the reason why they won't upload. I tried searching for a version 14.0 but can't seem to find it. Anyone encountered this problem before?

EDITS: I am using Windows 10 Pro. My version of MS Access is 64-bit. I have both Microsoft Office Access database engine 2007 and 2010 installed on my machine.

Outcomes