Access 2003 pivot table limits

G

Guest

I have a data table of 100,000 rows and I decided to play around with Access
2003's pivot table feature.

In the middle of creating the pivot table, I got the following error message:

"The query could not be processed: Error while processing a partition:
'Processing error [More than the maximum of 64,000 dimension member children
for a single parent]' "

Using a 3.2ghz dual core processor with 2.5 gb of ram. I seriously doubt
that caused this error.

Am I looking at a limitation of Access 2003? Any reference material
available which discusses this limitation?

Thanks,

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top