InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
When I try to connect to an Access database I get the above error message. This is the code I've used:
conn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\Users\wijnans\Documents\Dique-Opt\Scripts_Dique-opt\AccessDatabaseRWS.mdb;')
Using Python 3.6.13
Tried several things for fixing this problem, mdb instead of accdb, checked if path is correct.
