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!
Without the ODBC-ODBC Bridge, a 64-bit application cannot connect to a 32-bit ODBC driver. 64-bit applications must be linked against 64-bit libraries. For this reason, 64-bit applications can only link against a 64-bit ODBC Driver Manager library. 64-bit ODBC Driver Managers can only load 64-ODBC drivers.
The 32-bit and 64-bit versions of Office programs aren't compatible, so you can't install both on the same computer. You're developing in-house solutions, like add-ins or document-level customization. Your organization requires that Hardware Data Execution Prevention (DEP) be enforced for Office applications.
The choice depends entirely on the SQL client that is going to be used, e.g. the software that will make the ODBC connection to the OpenEdge database. The ODBC driver architecture (32-bit / 64-bit) must match the architecture of the SQL client.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With