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!

escape the single quotes with a single quote as a replace function.

stripQuotes()

Hi you can use replace function in vb
if u r using ASP
strIn=Replace (strIn, "'", "''")