cnxn = pyodbc.connect(
    'Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=C:\\Users\\...............(file location)'
    )
cursor = cnxn.cursor()
cursor.execute(
    'UPDATE progress SET CockpitDrill = ? WHERE progress_primarykey = ?',
    newcockpitdrillvalue, oldprimarykeyvalue)
SQL Update statement but using pyodbc