Reply to thread

Message: [QUOTE="Sylvain Lafontaine, post: 2151489"] I'm very confuse that doubling the double quotes solve the error message but also get save as double - double quotes. It should be one or the other but not both. It's probably because we don't see the whole picture here on what you are doing exactly. Is it possible that you are double-doubling them or that you are using a single quote as the delimiter somewhere or that you are storing part of the sql string in a variable or somewhere else to be used/concatenated again later? Using the single or the double quotes and when to double them or not can be very confusing sometimes and like always, the Devil likes to hide himself in the details. -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: [URL]http://coding-paparazzi.sylvainlafontaine.com[/URL] Independent consultant and remote programming for Access and SQL-Server (French) [/QUOTE]