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 ('webjxcom', '000000', 'My success is inseparable from everyone's support ')
