Главная страница | назад





Article #15012: 'Syntax error in query. Incomplete query clause'

 Question and Answer Database

FAQ12B.txt   'Syntax error in query. Incomplete query clause' 
Category   :Database (MSACCESS)
Platform    :Win95/NT
Product    :  

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
 

Last Modified: 01-SEP-99