My Pivot Table ??????????????

[shiro]

Hi All,
I have a pivot table in excel which it datas comes from a database.
I've just perform user level security wizard to my db.
The user level security wizard causes my pivot table unable to
to connect/read data from the database.How to solve this problem?


It sends me error message when trying to pen my excel pivot:
"[Microsoft][[ODBC Microsoft Access Driver]Record(s) cannot be read
;No read permission on 'Pivot Excel"

Hope somebody would like to help."


Regards,

shiro

 

[Guest]

Well it looks like you should give the user the reading rights in your user
level security. Remeber that you pivottable in Excel is made up from a source
in Access. If this source contains a query you should enable reading rights
on the used table in the query as well.

hth