By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

PIVOT Chart in MS ACCESS

P: 2
Hello all

I have realy big problem. I have txt file linked as linked table to my mdb database. This table can contain aproximatelly 1 000 000 records (teoretically), but real count is 100-500 000 records. I have based Pivot chart on this table, but it takes maybe 2 minutes until data are accessed and prepared. Then it takes more then 3 minutes to refresh data according user selection. This table is STAND ALONE, without relations to other table. Is there any possibility to speed up this PIVOT Chart routines and problem? Please help me, I have no idea what to do...
Jul 23 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.