I haven't written ASP code for a long time. Today when I was making a simple guestbook, an error occurred. Microsoft office Access Database Engine error '80040e14'
Syntax error for Insert INTO statement.
After checking the information online, I found out that the error was caused by the following reasons:
1) Use reserved words as names. Most databases have a set of reserved words. For example, name is a reserved word and cannot be used for column names in the database.
2) Use special characters in the name. Examples of special characters include: . / * : ! # & - ?
3) Use spaces in column names.
4) This error also occurs when an input mask is defined for an object in the database and the inserted data does not match that mask.
There are two ways to solve this problem:
1) When specifying column names in the database, please avoid using reserved words such as name, date, where, select, and level. Also, please remove spaces and special characters
2) When the field name is the same as a reserved word, we can use [] in the sql statement to distinguish them.
Insert into messages([names],qq,content) values ('WebjxCom','76312395','My success is inseparable from everyone's support')