my access pivot table says the query cannot be processed.

[Guest]

While creating a pivot table in Access 2002, I get a message saying the query
could not be processed: The cube file cannot be opened for writing. What
does this mean and what can I do?

 

[[MVP] S.Clark]

Try to Google the exact error message. See what other's have found.

Also, IMHO, Pivot Tables don't get as much use from the Access side as they
do from the Excel side, so maybe try the Excel newsgroups, or even an Access
one that deals more with the Pivot table functionality.(if there even is
one.)