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

  • Thread starter Thread starter shiro
  • Start date Start date
S

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
 
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
 
Back
Top