Help with apostrophes inserting into database

I am trying to capture form data from a web page using asp. This data goes into an Access 97 db. The data and pages work fine except when a user puts in an apostrophe. I know to use the replace function but when I do, after submiting I get an error. Just for clarification am I supposed to use the replace function on the form page or the reponse page that inserts the data? Any other help would be appreciated! Thanks

What error do you get?

Use the replace function on the same page that inserts the form data into the database.