MS Access Tutorial: Microsoft JET Database Engine error '80040e14'. Syntax error in UPDATE statement

Solution for the Error: Microsoft JET Database Engine error '80040e14'. Syntax error in UPDATE statement

You will also get the above error sometimes while executing the INSERT statement.(Syntax error in INSERT statement)

This occurs when your database table field name is a reserved keyword. Change your field names or your SQL statement to avoid such problems.

In the below example, one of the field name is "password" which is the access reserved keyword. If you use this keyword as your field name, you will get the above error during field updation. So to avoid this you can use [ ] to delimit the field names, like shown below: