title: Pyodbc - The specified DSN contains an architecture mismatch between the Driver and Application
body: <p>I'm trying to connect to a MS Access Database (.accdb file) via python.</p>
  
  <p>I used pyodbc to do this connection:</p>
  
  <pre><code>import pyodbc
  conn = pyodbc.connect("DRIVER = {Microsoft Access Driver (*.mdb, *.accdb)}; DBG=C:\\test_db.accdb")
  </code></pre>
  
  <p>However, I got the following error:</p>
  
  <pre><code>('IM002, '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
  </code></pre>
  
  <p>I went to the ODBC Data Source Administrator and when I tried to configure or remove the Driver I got the message:</p>
  
  <pre><code>Errors Found:
  The specified DSN contains an architecture mismatch between the Driver and Application
  </code></pre>
  
  <p>I found that this error is provoked by an incompatibility between versions of Windows (windows 7 - 64bit) and Microsoft Access (Office 2010 - 32bits).
  I tried to reinstall the driver several times, both with 32 and 64bit versions but the problem wasn't solved.
  Could you please help me to solve this problem? Thank you in advance.</p>