devine
07-03-2006, 05:52 AM
Hi All,
I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example:
I'm going to....
It's happening......
It'll take place......
The Conn.Execute(strSQL) statement then fails as it appears that it can process the date before the quote marks (i.e. It), but can't process the data following the quote marks (i.e ll take place)
Is there a simple solution to this problem?
Thanks!
I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example:
I'm going to....
It's happening......
It'll take place......
The Conn.Execute(strSQL) statement then fails as it appears that it can process the date before the quote marks (i.e. It), but can't process the data following the quote marks (i.e ll take place)
Is there a simple solution to this problem?
Thanks!