Hello!
I got a problem using apostrophe in the fields, upon I need to search a data I got error because the data has apostrophe, here is a example:
cVar="Bob's Sample"
cSearch="SELECT * FROM CUSTOMER WHERE BusinessName= '"&cVar&"'"
MyData.Open cSearch, objCmd, adOpenKeyset, adLockOptimistic, adCmdText

At this time I got error because the apostrophe, and if I try to not use apostrophe after BusinessName I got other error because it is a character and need the apostrophe.
Any advice or suggestion.

Thanks,

Gerardo