Posted by Rami Elomaa on 05/14/07 10:43

"Johnny BeGood" <jbg@jbg.net> wrote in message
news:U0B1i.19580$j7.373487@news.indigo.ie...
> Hi All,
>
> When a user enters an Apostrophe into a text area field on a form, i.e.
> didn't, it mucks with odbc as follows
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)
> in query expression ''didn't',
>
> Whats the best way to handle this, other than not entering the apostrophe.
> I'm stuck with the current backend database as its part of an existing
> application.
>

Apostrophes are escaped by another apostrophe. Ie. 'didn't' should be
entered as 'didn''t'. At least this is how it works in MS SQL, and I'm
certain that Access has the same syntax.

--
Rami.Elomaa@gmail.com

"Good tea. Nice house." -- Worf

[Back to original message]