The MMC of the ODBC administrator is pointing to the 64bit version, but Microsoft Access keeps opening the 32bit version. The problem is that Microsoft Access keeps opening the 32bit version. If neither driver is listed, check the 32-bit ODBC Administrator. Typical driver versions range from 14.0 to 16.0. If these drivers are present, this confirms the existence of 64-bit ACE components. I need it to open the native 64bit version, which it is not opening. When the ODBC Administrator opens, click the Drivers tab and look for Microsoft Excel Driver or Microsoft Access Driver. How can I get Access to use the 64bit ODBC administrator?įor clarification, the problem is that Access is opening the 32bit version, the syswow64 version. 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.Ĭan 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. If I use this version of the ODBC administrator, I can see the Oracle drivers and my DSN via the mmc. 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 click the ODBC mmc in my admin tools I can see the DSN.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |