Running speed of Micrsoft Query with Multiple parameters

[Ken]

Hi!,

I created a query with eight parameters. When refreshed, the query will
obtain the eight parameter values from 8 different linking cells in a
worksheet.

If I enter a parameter value and leave the rest of 7 cells blank, the
running speed is still about the same (as slow) as the case with 8 parameters
entered. Normally, a query with only one parameter is very fast.

I also have a query with about 50 parameters. It takes a very very long
time to run the query, even though only one parameter was entered.

With the option to enter from 1 to 8 paramaters, I am wondering if there is
any way to make the query run faster when less parameters are entered.

Thank you very much!

Ken

 

[Nick Hodge]

Ken

Not really as you are using MSQuery and ODBC so I suspect it is passing all
parameters, despite the fact you have only one with a value (The others will
be passing null to the parameter collection.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk