AnsweredAssumed Answered

Conflict w/2007 Office System Driver and Access 2016

Question asked by spectre813 on Nov 8, 2017

Anyone seen this one? 2007 Office System Driver seemed to be fine until we hit Office 2016. Seeing little to nothing useful through Google or perusing the community so far.

 

Windows 2012 R2

ArcGIS 10.2.1 UTUP5

ArcFM 10.2.1

 

1) Issue adding XLSX files through Add Data. No issues reported with other file types.
2) Install ESRI recommended 2007 Office System Driver.
3) XLSX problem solved.
4) Now Access 2016 doesn't work...allow Access 2016 to configure itself.
5) Access 2016 works...XLSX problem now back -- along with a SEEMINGLY new issue of an error "Failed to connect to database. General function failure. Unexpected error from external database driver (1)." when loading an XLS (not XLSX) file.

Outcomes