Hi!
I have a database containing filenames, and some of them uses the ' character. (ex. "peter's file.txt"
I'm using a MFC recordset to connect to the database.
Problem is that when I want to filter records Access don't like strings with ' at all, since it thinks this is the end of a string, and not a character in the string.
Does anyone know how to fix this?
Thanks,
Peter Logarn
I have a database containing filenames, and some of them uses the ' character. (ex. "peter's file.txt"
I'm using a MFC recordset to connect to the database.
Problem is that when I want to filter records Access don't like strings with ' at all, since it thinks this is the end of a string, and not a character in the string.
Does anyone know how to fix this?
Thanks,
Peter Logarn