Solution to ASP code error 80040e14

Source: Internet
Author: User

I haven't written ASP for a long time CodeToday, when I made a simple message book, I encountered the following error:
Microsoft Office Access database engine error '80040e14'
The syntax of the insert into statement is incorrect.
I checked the information online to find out the cause of the error:
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 as the column name in the database.
2) special characters are used in the name. Examples of special characters include :./*:! #&-?
3) use spaces in column names.
4) This error also occurs when the input mask is defined for the object in the database and the inserted data does not match the mask.
There are two ways to solve this problem:
1) when specifying the column name in the database, avoid using reserved words such as "name", "date", "where", "select", and "level. In addition, clear spaces and special characters.
2) When the field name is the same as the reserved word, we can apply [] to the SQL statement to distinguish it.
Insert into messages ([names], QQ, content) values ('jb51. net', '000000', 'success is inseparable from everyone's support ')
For a list of Reserved Words in common database systems, refer to the following webpage:
SQL Server 2005 http://technet.microsoft.com/zh-cn/library/ms143507.aspx
Microsoft Access 2007 http://office.microsoft.com/zh-cn/access/HA100306432052.aspx
Microsoft Access 2000 http://support.microsoft.com/default.aspx? SCID = KB; en-US; q209187
MySQL http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.