Help: pivot chart data in secured Access database wont show fields
 

Hello

Is there a way for me to crate a pivot chart in Excel where the data is in a
secured access database.

By default (ie using system.mdw) the Access security allows a user view
permissions on the tables. When connecting to the database the tables are
visible, but the next step where the fields get shown doesnt happen, no
fields can be selected.

Is this a security issue? Is there a way around this?

Thanks
A