This article outlines two ways to resolve the 80040e14 error. I haven’t written ASP code for a long time. When I was making a simple guestbook today, 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 ('vevb.com','76312395','My success is inseparable from everyone's support')
For a list of reserved words in common database systems, please refer to the web page:
SQL Server 2005http://technet.microsoft.com/zh-cn/library/ms143507.aspx
Microsoft Access 2007http://office.microsoft.com/zh-cn/access/HA100306432052.aspx
Microsoft Access 2000http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209187
MySQLhttp://dev.mysql.com/doc/refman/5.0/en/reserved-words.html