Question:
"Syntax error in query. Incomplete query clause" error:
I get this error when I run a query against a table with a
space in the table name. I have double quotes around the name
but it still does not work. What am I doing wrong?
Answer:
You need to change the double quotes " " to brackets [ ]
Example:
SELECT * FROM "MY TABLE NAME" needs to change to
SELECT * FROM [MY TABLE NAME]