Jet flow

[Ryan]

Query qryTest2's record source is qryTest1. Query qryTest3's record source
is also qryTest1. Does Jet query qryTest1 2 times, or once and gives data to
qryTest2 and qryTest3? I hope this makes since. Im just trying to find out
if two queries use the same query as a datasource if Jet queries that data
source once or twice.
--

 

[Bob Barrows [MVP]]

Query qryTest2's record source is qryTest1. Query qryTest3's record
source is also qryTest1. Does Jet query qryTest1 2 times, or once
and gives data to qryTest2 and qryTest3? I hope this makes since.
Im just trying to find out if two queries use the same query as a
datasource if Jet queries that data source once or twice.

I think you are asking if Jet caches query results for re-use. I'm not sure,
but I don't think so.

 

[Marshall Barton]

Query qryTest2's record source is qryTest1. Query qryTest3's record source
is also qryTest1. Does Jet query qryTest1 2 times, or once and gives data to
qryTest2 and qryTest3? I hope this makes since. Im just trying to find out
if two queries use the same query as a datasource if Jet queries that data
source once or twice.

Hard to tell. OTOH, if you time the same same query several
times, the first time is usually(?) much slower. This seems
to imply that something (table indexes, records or ??) is in
some kind of Windows, Access or Jet cache.