Syntax error in UPDATE statement.
I get this error a lot when using the Update Form Wizard in Dreamweaver. This time it turns out I was using a field called "password", which is a reserved field in MS Access. To fix the problem I had to change:

password=
  <cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
    '#FORM.password#'

to:

[password]=
  <cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
    '#FORM.password#'

Archives