Syntax error in UPDATE statement OleDbException

c#,sql,oledb,oledbexception,updateexception

The UPDATE syntax is UPDATE <tablename> SET field1=Value1, field2=Value2 WHERE primarykeyname=Value3 The SET keyword precedes only the first column to update, and you have another problem with the NAME column. In Access this is a reserved keyword. Use brackets around that column name (or better change it to something not...