Link to MS-Access Query
 

I'm using the pivot table wizard to link to an Access query, however, it's
failing in that I can select the query, but it doesn't show the data elements
(no error, it just doesn't work). I can link to tables in the Access
database, but not any of the queries. The database has password restrictions,
but the default admin password has full rights. Ideas?