Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
I want to do a hand install of the MS Access 64 bit odbc drivers. Uninstalling 32 bit Office and installing 64 bit Office is not an option due to the add-ins that our company uses.
I downloaded the AccessDatabaseEngine_x64.exe and using WinRar and Universal Extractor have managed to unpack all the files into a temp directory. I believe I have all of the files necessary but am a bit unsure where to go from here and would appreciate a little guidance.
Which DLLs need to be registered to make the MS Access ODBC drivers available in the 64 bit ODBC administrator?
Is there a list of registry entries that I will need to make for it to be available?
Has anyone else dealt with this in a reasonable manner?
Thank you in advance!
Answer
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.