title: How to connect MS Access to Python using pyodbc
body: <p>I'm having trouble connecting a database in access with pyodbc. I've seen other example codes that appear near identical to mine that work:</p>
  
  <pre><code>import pyodbc 
  cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=PYODBC.accdb;UID=me;PWD=pass')
  cursor = cnxn.cursor()
  
  cursor.execute("SELECT Forename FROM Student")
  row = cursor.fetchone()
  if row:
      print(row)
  </code></pre>
  
  <p>My machine is running on windows 7 home premium 64-bit.
  I have Microsoft office 2010; 32-bit
  I'm running python 3.3; 32-bit</p>
  
  <p>I have no idea whats wrong with it, I don't even get an error message, the shell opens, but nothing happens. Any help is greatly appreciated </p>