I am getting in error if i try to add or update an record that has apostrophe in it. eg Bob's. it would give me error if i try to update this record or add this record
replace a ' with '' (2 single quotes)
.. on AspFaqs.com. In one of the Databases categories.