Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
To install the Microsoft Access 2016 ODBC Driver, run the installer from the command line with the /quiet
switch (which replaces the /passive
switch from previous versions).
You'll also need to delete or rename the mso.dll registry value in the following registry key:
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths
This information collected from the Data Savvy blog.
using the /passive switch you can install 64-bit ace drivers even if 32-bit ms office is present: http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
Just be warned that installing the 2010 64-bit ACE engine on a machine with 2010 32-bit Office already installed CAN lead to some wacky behavior in your already existing Office 2010.