Running same qry back-to-back

[Razor]

Hi,

If I run the same query twice back-to-back, how can I make
Access cache the results from the first execution so the
second execution proceeds faster?

Thanks!

razor

 

[Marty]

Make a copy of the query, paste it with a new name, then
create a MACRO to run the two queries.

Marty

 

[James]

Use the 'Prepared' property of the Command object of VBA for Access.

----- Razor wrote: -----


Hi,

If I run the same query twice back-to-back, how can I make
Access cache the results from the first execution so the
second execution proceeds faster?

Thanks!

razor