在access2000+d5中下面的情况还存在吗?
Article #15012: 'Syntax error in query. Incomplete query clause' Question and Answer DatabaseFAQ12B.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] 改这里
Article #15012: 'Syntax error in query. Incomplete query clause' Question and Answer DatabaseFAQ12B.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] 改这里
我的表名不是用中文和空格的要是表名有空格,[]是必须的,Access 2000/XP+D6/7都是这样
所以你还需要使用格式SELECT * FROM [MY TABLE NAME]