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 names. 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 2005
Microsoft Access 2007
Microsoft Access 2000 ?scid=kb;en-us;Q209187
MySQL