title: cannot connect to 64bit MsAccess database with 64bit Python 3.6.ODBC Driver Error
body: <p>I have just installed 64-bit microsoft office on a new computer and also installed 64bit python 3.6. </p>
  
  <p>I'm trying to connect to an access database with my python script, however I keep getting the following error which suggests I have the 32bit ODBC driver instead of the 64bit driver?</p>
  
  <p>Any ideas on how to connect without having to install 32bit MS Office and 32bit Python?</p>
  
  <p>This is the error message I get:</p>
  
  <p>cnxn = pyodbc.connect(connstr)
  pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')</p>
  
  <p>Here's my code:</p>
  
  <pre><code>import pyodbc
  connStr = (
            r"DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};"
            r"DBQ=C:\Documents\Test.accdb;"
            )
  cnxn = pyodbc.connect(connStr)
  cursor = cnxn.cursor()
  cursor.execute("SELECT * FROM Test")
  </code></pre>