How do you get Microsoft Access 2007 32bit to show 64bit ODBC Drivers on Windows 7 64bit?

Posted by johnny on Stack Overflow See other posts from Stack Overflow or by johnny
Published on 2012-09-10T21:12:59Z Indexed on 2012/09/10 21:38 UTC
Read the original article Hit count: 255

Filed under:
|
|
|

I followed the advice here:

Windows 7 64 bit odbc drivers for Ms Access Missing

but it does not apply.

I have Oracle drivers that are 64bit. If I click the ODBC mmc in my admin tools I can see the DSN. In my properties of the ODBC administrator, it appears to be pointing to the 64bit version of the ODBC administrator, which is good:

%windir%\system32\odbcad32.exe

If I use this version of the ODBC administrator, I can see the Oracle drivers and my DSN via the mmc. When I go to Microsoft Access 2007 (32bit), however, and click external data, ODBC, my 32bit ODBC administrator is opening, which does not have the driver.

Can Access 2007 32bit use a 64bit driver to connect to a database (oracle in this case)? The driver works fine in all other applications, just not Access. How can I get Access to use the 64bit ODBC administrator?

EDIT:

For clarification, the problem is that Access is opening the 32bit version, the syswow64 version. I need it to open the native 64bit version, which it is not opening. The problem is that Microsoft Access keeps opening the 32bit version. I need it to open the 64bit version. The MMC of the ODBC administrator is pointing to the 64bit version, but Microsoft Access keeps opening the 32bit version. I need it to open the 64bit version. Thanks for help.

© Stack Overflow or respective owner

Related posts about windows-7

Related posts about odbc