title: SQL link to Access database error
body: <p>I am having an issue with saving some data via SQL to a database. This code worked originally:</p>
  
  <pre><code>cnxn = pyodbc.connect('Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=C:\\Users\\george\\Documents\\Homework\\Computing\\Monkey Studio\DrivingSchoolDatabase.accdb')
          cursor = cnxn.cursor()
          cursor.execute("insert into Students(Forename,Surname,Address1,Address2,PostCode,Home,Mobile,Email,License,Expiry,Medical,DOB,EyeTest) values (?,?,?,?,?,?,?,?,?,?,?,?,?)",forename,surname,address1,address2,postCode,homePhone,mobilePhone,email,license,expiry,medical,DOB,eyeTest)
          cnxn.commit()
          QtGui.QMessageBox.about(self, 'Saved','Student data saved')
          self.close()
  </code></pre>
  
  <p>I then added two new fields into the access database and added them to the code so I had this (the two new variables are previous and where):</p>
  
  <pre><code>cnxn = pyodbc.connect('Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=C:\\Users\\george\\Documents\\Homework\\Computing\\Monkey Studio\DrivingSchoolDatabase.accdb')
          cursor = cnxn.cursor()
          cursor.execute("insert into Students(Forename,Surname,Address1,Address2,PostCode,Home,Mobile,Email,License,Expiry,Medical,DOB,EyeTest,Previous,Where) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",forename,surname,address1,address2,postCode,homePhone,mobilePhone,email,license,expiry,medical,DOB,eyeTest,previous,where)
          cnxn.commit()
          QtGui.QMessageBox.about(self, 'Saved','Student data saved')
          self.close()
  </code></pre>
  
  <p>I now get this error:</p>
  
  <pre><code>Traceback (most recent call last):
  File "C:\Users\george\Documents\Homework\Computing\Monkey Studio\AddAStudent.py", line 118, in AddCreateStu
  cursor.execute("insert into Students(Forename,Surname,Address1,Address2,PostCode,Home,Mobile,Email,License,Expiry,Medical,DOB,EyeTest,Previous,Where) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",forename,surname,address1,address2,postCode,homePhone,mobilePhone,email,license,expiry,medical,DOB,eyeTest,previous,where)
  pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Microsoft Access Driver]           Syntax error in INSERT INTO statement. (-3502) (SQLExecDirectW)')
  </code></pre>
  
  <p>I'm probably missing something simple.</p>