I'm importing several names from one program to another (but this problem came to me several times in the past), and the software from where i'm importing the clients names have the character '
When i try to filter the data in the database, like for instance:
I get an error.
if i do the same when trying to open the recordset, like for instance:
recordset.open("Select * from table where name='M. J'Anne'")
i also get an error
Is there anyway to overcome this problem
my thanks in advance