Running same qry back-to-back

  • Thread starter Thread starter Razor
  • Start date Start date
R

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
 
Make a copy of the query, paste it with a new name, then
create a MACRO to run the two queries.

Marty
 
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
 
Back
Top