title: How do you get Microsoft Access 2007 32bit to show 64bit ODBC Drivers on Windows 7 64bit?
body: <p>I followed the advice here:</p>
  
  <p><a href="https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing">https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing</a></p>
  
  <p>but it does not apply.</p>
  
  <p>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:</p>
  
  <pre><code>%windir%\system32\odbcad32.exe
  </code></pre>
  
  <p>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.</p>
  
  <p>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?</p>
  
  <p>EDIT:</p>
  
  <p>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.</p>