title: SQL Update statement but using pyodbc
body: <p>I am using a pyodbc driver to connect to a microsoft access table using SQL. Does anyone know how I go about replacing fields within this table?? I have though about deleting the row and then putting the row back but that would change the primary key due to the autonumber in access.</p>
  
  <p>I have this for inserting into the Progress table:</p>
  
  <pre><code>        cnxn = pyodbc.connect('Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=C:\\Users\\...............(file location)')
          cursor = cnxn.cursor()
          cursor.execute("insert into Progress(CockpitDrill,Mirrors,MoveOff,TurnLeft) values (?,?,?,?)",cockpit,mirrors,moveOff,turnLeft,)
          cnxn.commit()
  </code></pre>
  
  <p>So how would I replace these fields. Let's say I wanted to change CockpitDrill from '2' to '3', (They are all strings).</p>
  
  <p>Any help would be greatly appreciated.</p>