Trouble linking data source to pivot table

[marksuza]

Hi,

I am trying to create a pivot table based on a query that I created in
access, but I am getting the following error message "Syntax error in
FROM clause". I dont have access to the master database, the query I
created is in a linked copy of the master. Can anybody explain me what
this error message means and how I can solve, please. Thanks.

Marcos

 

[gdb]

-----Original Message-----
Hi,

I am trying to create a pivot table based on a query that I created in
access, but I am getting the following error message "Syntax error in
FROM clause". I dont have access to the master database, the query I
created is in a linked copy of the master. Can anybody explain me what
this error message means and how I can solve, please. Thanks.

Marcos


---
Message posted

.
I have that kind of problem every time i use alias in a

select line via msquery.
This bug on msquery 2002 is describe in 298955 but i
don't understand why there is no direct link on a hotfix.
Was this bug fix in the office pack 3 ?
I thought it was... but it is not.
I am looking for the hot fix.

Thanks

 

[marksuza]

Do you know how to go around it? The error says it is a problem wit
the driver. I am completely ignorant there, what does that mean?
Thanks