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]


7/15/98 3:23:06 PM

2 Responses so far.

Post a Comment

Thank you for your comment.

Any request and idea are welcome.

CLICK TO REGISTER