Optimizing speed of Pivot Tables

D

Dave

I have an Access 2003 database with several linked tables (views) from
a SQL Server 2000 database. I'm using several Pivot Table forms within
it. It takes quite a while for the data to load into Access before data
appears. Are there any suggestions to speed this process up? Will an
..adp file be faster?

Thanks,

Dave
 
Top