Hi, can anyone help with this problem as its stopped me continuing to develop my app. I just can't see what is wrong.
I have used MS Access with Delphi last time more than 15 years ago. I can hardly remember, but double and single quote where differently meaning. I have used ADO component with Delphi, however I have no idea what is using with Lazarus. Even worse, I do not use Windows anymore...
However, you can provide some very simple Lazarus source with test database, perhaps someone will help.
However, I do not think that kind of SQL expression will be accepted from MS Access driver, I believe strings (and table names) need to be double quoted.
If I can remember correctly, with ADO there was two separated methods: one was to provide clean string and execute commands only (UPDATE and similar), EXECUTE method or similar. Another was to use QUERY methods with SQL queries which returns data, as upper.