get around apostrophies

[chappi]

How can I get around the issue with apostrophies. I have an access database and wrote an ASP.NET front-end to it. But when I try to enter something with an apostrophy (like a name) the querystring breaks. I know with SQL Server you can use parameters, but I'm not sure about Access.
Any thoughts?

J

 

[Isadore]

From our well respected expert link9 (Paul) provided the following solutin some time ago:

Dim strSite As String
strSite = lblSite.Text
strSite = strSite.Replace("'","''&quot

...this effectively removes the apostrophie but when you insert the record in a table, the apostrophie comes back intact.

 

[chappi]

Thanks. I also just saw a post that answered a similar question. Thanks anyways for your quick response