Is it possible to find a record on an Access database when the name you are looking for contains an apostrophe? E.g. St Mary's Bakers. I am doing a search on Customer name and get a runtime error 3077 whenever there is an apostrophe.
I am using Findfirst with the name as a string.