B
B Golden
This is the silly question for the day! But, do Macros in Access (2003 if it
makes a difference) run sequentially? By that I mean if I have a Macro that
runs a number of select Queries, does the Macros wait for one to inish before
starting another?
I am using a Quad Core processor. Some of the Query results are leading me
to belive that possibly the Macro can run more than one Query at a time. For
example, one Query checks for duplicates in a field. The output from the
Macros running the query is x. If I immediately run the same Query by itself
after the Macro finishes, I see x+6 duplicates. the x+6 os correct. The
Macro does not run any query that would add records. Immediately running the
Macro again produces the original x number of duplicates.
If the Macro is capable of running more than one Query simultaneously,
possible a record is locked when the duplicate checking query hits that
record?
Just curious.
Thanks
Bob
makes a difference) run sequentially? By that I mean if I have a Macro that
runs a number of select Queries, does the Macros wait for one to inish before
starting another?
I am using a Quad Core processor. Some of the Query results are leading me
to belive that possibly the Macro can run more than one Query at a time. For
example, one Query checks for duplicates in a field. The output from the
Macros running the query is x. If I immediately run the same Query by itself
after the Macro finishes, I see x+6 duplicates. the x+6 os correct. The
Macro does not run any query that would add records. Immediately running the
Macro again produces the original x number of duplicates.
If the Macro is capable of running more than one Query simultaneously,
possible a record is locked when the duplicate checking query hits that
record?
Just curious.
Thanks
Bob