I always specified criteria using the SQL Where clause. This allows the
database to use it's own optimisation techniques to retrieve the data
fastest.

I've never used the Filters feature of ADO.
Perhaps using Server Side connection will speed things up - just a guess.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"John" wrote in message
om...
Here's my setup:

Pivot table uses an ADODB connection to pull from a single Access
database table that contains about 1 million records. A user form
contains parameters that will filter the dataset so the ADODB
connection doesn't have to pull in the entire table.

The problem is, even with filters the query still moves at a slow
pace. Does the size of the table have an effect on the query
performance---ie, regardless of how or what's filtered, the bigger the
table the slower the query speed??

Is there a way to improve the query performance? Maybe adjusting the
"MaxBuffer" setting in the cache...not sure what that is even. Or
something else?