Hi, this is probably a bit of a n00b question, but if there are single quotes in SQL queries, how do you stop Jet from misinterpreting them as part of the statement syntax? In PHP/MySQL I would use a backslash before the quote - is it the same with VBA/Jet? So for example, I would want to make the correct version of this statement:
INSERT INTO Names (Surname) VALUES ('O'Neill');
Also, often these names are coming from another file or user input, so is there an "automatically escape bad characters" function, so I could do
"INSERT INTO Names (Surname) VALUES ('" & auto_escape(txtSurname) & "');"