con = pyodbc.connect(
    'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=Z:\\Data\\Instruments\\testDB.accdb; Provider=MSDASQL;'
    )
cur = con.cursor()
Cant Create tables in access with pyodbc