Subscribe
Please visit my new Web Site https://coderstechzone.com
You may face the "Error: 80040E14 - MS Access Syntax Error message" when you want to execute or run an Insert, Update, Delete or even Select statement. There were several types of error you may encounter like below:
1. Syntax error in FROM clause
2. Syntax error in INSERT INTO statement
3. Syntax error in UPDATE statement
4. Syntax error (missing operator) - caused by ' mark
5. Syntax error (missing operator) - incorrect delimiters
6. Syntax error - division by zero error
7. Mismatched CommandTypeEnum value
The above error may comes for below reasons:
1. Using a Reserved Word for a field name or for a table name.
2. Spaces between field name or table name
3. Attempting to insert single quote within a string/text value
4. Incorrect syntax or typing mistake
Resolution:
Using a Reserved Word for a field name or for a table name:
If you are using any reserve word of MS-Access as a field name or table name then you encounter the error. The simple solution is wrap up the field name or table name by third bracket like:
Select [name], [password], [email] From [Agents]
Spaces between field name or table name:
If you are using any spaces within a field name or table name then you encounter the error. The simple solution is wrap up the field name or table name by third bracket like:
Select [name], [password], [email address] From [Agents]
Attempting to insert single quote within a string/text value:
If you want to insert a text or string value which contains single quotation like 'What's in your mind?' within the value then you encounter an error. Because the single quote telling MS-Access that the string value has ended, and anything afterwards should be treated as legitimate SQL. The simple solution is use string.Replace() method to double any single quotes will resolve your problem. Paramterised queries also the best solution in this regard.
Incorrect syntax or typing mistake:
Try to learn MS-ACCESS SQL syntax will resolve your problem.
