Unanswered: Need to speed-up multiple cross tab queries through ADO
I'm using an Excel front-end for users to query a large Access database to retrieve 30 or so cross-tab queries. The whole process is now taking 15 minutes or so to run, and I'm wondering if it is because each of my 30 SQL statements from Access has a pretty hefty Select statement associated with it. I've tried first creating a temptable to do the Select for me and to run all the cross-tabs from the temptable, but it is taking longer to create the temptable than it did to run all the cross-tabs from a select query.
Is there any way through VB with ADO to have a single query extract the relevant info before I run all the cross tabs? Or, do you have any thought on what else may be causing this to take so long?