« INSERT funtion
Open a directory »

Microsoft JET Database Engine (0×80040e14) Syntax Error (Missing Operator) in query expression

Microsoft JET Database Engine (0×80040e14) Syntax Error (Missing Operator) in query expression

This is commonly caused when some value that you are trying to SELECT/UPDATE etc contains a single quote mark. The error that you receive looks like:

Microsoft JET Database Engine (0×80040e14)
Syntax error (missing operator) in query expression ‘Name = ‘Carolyn O’Tooley'’.
Because of the presence of the ‘ in the name Carolyn O’Tooley the database engine thinks that you are constructing a WHERE clause like:

WHERE name = ‘Carolyn O’
and doesn’t know what to do with the rest of the name (Tooley). To solve this problem you need to use the Replace() function and replace all single quotes with two single quotes.

This entry was posted on Wednesday, January 24th, 2007 at 11:26 am and is filed under asp development, ms access database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Microsoft JET Database Engine (0×80040e14) Syntax Error (Missing Operator) in query expression”

  1. John Says:
    July 9th, 2008 at 1:57 am

    thanks you great to be the first :P
    and good tip cuz I have this error this make me made I hope thats works thanks you again

Leave a Reply

All material @ copyrighted by chrisranjana.com. If you want to link to this article you are welcome to do so. Unauthorized publication is strictly prohibited. This developer tutorial website contains articles by Php programmers , Software developers, Mysql programmers and asp c# programmers. This website also contains ajax tutorials and advanced mysql sql stored procedures and functions tutorials and sample codes.