title: Connecting 32-bit R to a 32-bit Access database
body: <p>I am using 32-bit <code>R</code> with RStudio to try and connect to an <code>.accdb</code> file.  I have 32-bit MS Access running on my machine.  </p>
  
  <p>R version: </p>
  
  <pre><code>platform       i386-w64-mingw32            
  arch           i386                        
  os             mingw32                     
  system         i386, mingw32               
  status                                     
  major          3                           
  minor          1.2                         
  ...
  language       R                           
  version.string R version 3.1.2 (2014-10-31)
  nickname       Pumpkin Helmet
  </code></pre>
  
  <p>I'm trying to use the <code>RODBC</code> package to connect to an MS Access database. I cannot use <code>odbcConnectAccess("location_of_database.accdb")</code> to connect to a database provided by a client.  This particular database was created with Access 2013.  When I try to connect, I get a variety of warning messages:</p>
  
  <pre><code>Warning messages:
  1: In odbcDriverConnect(con, ...) :
    [RODBC] ERROR: state HY000, code -1028, message [Microsoft][ODBC Microsoft     Access Driver] Cannot open database '(unknown)'.  It may not be a database that     your application recognizes, or the file may be corrupt.
  2: closing unused RODBC handle 12 
  3: In odbcDriverConnect(con, ...) :
    [RODBC] ERROR: state 01000, code 1, message [Microsoft][ODBC Microsoft Access Driver]General Warning Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x11a4 Thread 0x798 DBC 0x88e0064 Jet'.
  4: In odbcDriverConnect(con, ...) :
    [RODBC] ERROR: state 01000, code 1, message [Microsoft][ODBC Microsoft Access Driver]General Warning Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x11a4 Thread 0x798 DBC 0x88e0064 Jet'.
  5: In odbcDriverConnect(con, ...) : ODBC connection failed
  </code></pre>
  
  <p>Interestingly, I can use <code>odbcConnectAccess2007()</code> to connect successfully to databases that were created with <em>Access 2010</em>; however, when I try to use <code>odbcConnectAccess()</code> to connect to those same databases, I get the same errors above.</p>
  
  <p>A Google search of the <code>Error: state 01000, code 1</code> message above suggests that <a href="https://support.microsoft.com/en-us/kb/295297" rel="nofollow noreferrer">this page</a> may be helpful, but even after following the steps to alter the <code>HKEY_LOCAL_MACHINE</code> does not work.</p>
  
  <p>While I originally thought <a href="https://stackoverflow.com/questions/26244425/general-error-unable-to-open-registry-key-temporary-volatile-from-access">that this question was promising</a>, the warning message there relates to "ACE DSN" while the error messages I'm seeing relate to "Jet DSN."</p>
  
  <p>I cannot open the databases I'm trying to access with <code>RODBC</code> with my version of Access as the databases were created with Access 2013 and I have Access 2010 installed.    </p>
  
  <p>Can anyone help me trouble shoot why I can't open this database with <code>odbcConnectAccess()</code>?  </p>