x64 ODBC Drivers (Access & Excel) not available after installing Office 365 2016 Pro-Plus...

  • Thread starter Thread starter YvesRoy
  • Start date Start date
Y

YvesRoy

Guest
I have installed recently Office 365 Pro-Plus 2016 64 bits version from my Office 365 (University) account on 2 machines, a laptop and a Surface Pro, all running Windows 10 Pro. All applications seem to work fine but something's lacking : the x64 ODBC Drivers for Access and Excel are not available in the 64 bits odbcad32.exe. At the opposite, everything is fine on a third machine (Windows 10 Enterprise) on which Office 2016 Professional Plus (Desktop) was installed.

After looking into the Program Files directory and the registry, I found two differences:
•The drivers' dlls usually stored in Program Files\Common\Microsoft Shared\Office2016 are, for the Office 365 machines, located in Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office2016. The contents are almost the same.
•But there are no references to it in the registry: no entry in HKLM\Software\ODBC\odbcinst.ini, and no "Access Connectivity Engine" in HKLM\Software\Microsoft\Office\16.0 or in the Access sub-key.

Is there somewhere a tool to register correctly the ODBC drivers in the Office 365 installation? Any help would be greatly appreciated, as I rely heavily on these drivers to exchange vast amounts of date between Office apps and the statistical packages I use.

Yves Roy, University of Poitiers, France

Continue reading...
 
Back
Top