Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present

Question

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!

Solution 1

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.

Solution 2

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.

Comments

[aljgom]

My computer restarted when I did this, so if you want to try this make sure you have saved your files in case it happens. Afterwards I tried it again and it seems to have worked (though my office is having a wacky behavior, but I can live with that for now)

[watbywbarif]

Can you explain wacky? I am unable to start MS Access at all and Word is trying and failing to install something for half a minute before it starts so this does not look like an option to me.

[Dai]

After installing the 2016 edition of AccessDatabaseEngine_X64.exe /quiet on my machine, I don't see the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\Fil‌​esPaths key in my registry at all - any idea? There's no Common key under Office\14.0 at all, and the other Common keys elsewhere in the Office tree don't contain FilesPaths.

[Dai]

UPDATE: Ah, I found it under Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\C‌​ommon\FilesPaths - I needed to Refresh my Registry Editor view.