Connect to a .mdb file with pyodbc: Which driver?

[Sava112233]

Environment

To diagnose, we usually need to know the following, including version numbers. On Windows, be sure to specify 32-bit Python or 64-bit:

• Python: anaconda 4.12.0 64-bit
• pyodbc: 4.0.32
• OS: Windows 10
• DB: MS Access
• driver: Microsoft Access Driver (.mdb, .accdb)

Issue

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\me\Desktop\db.mdb;')

That's how I solved the connection to a mdb database file. I want to list all elements with python, but I get a fail in this line. The message is: pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

What could be the reason for this?

[gordthompson]

Check the list returned by pyodbc.drivers() to see what ODBC drivers are available to your Python app.

[Sava112233]

Did it and got nothing. uninstalled access database engine and installed it again, than got the drivers. Thank you!!