I've got an access database which stores peoples names, and we have some forms that allow people to search on these names.

I'm having a problem searching on names like "O'Donnell" which has a quoation mark (chr(39)) in it. because it get's passed to access like this "Select * from table1 where surname ='O'Donnel'", it breaks the string after the letter.

Does anyone know a way around this. Many thanks.