How to connect MS Access to Python using pyodbc
ms-access, pyodbc, python
Solution
Since you are using the 32-bit versions of both Microsoft Office and Python you should be good to go once you have the right connection string. It should look like this:
connStr = (
r"DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};"
r"DBQ=C:\full\path\to\your\PYODBC.accdb;"
)
cnxn = pyodbc.connect(connStr)
Problem
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: ``` 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) ``` 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 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