Apostrophe in textfield

ASP and Access. User enters any of the following:
BOB CARS
“BOB CARS”
BOB CARS”
and it enters fine in the database.
User enters:
BOB’S CARS
and an error is produced. I imagine I have to somehow REPLACE the apostrophe. What’s the recommended prodecure?