E
Emmweb
I have a macro which runs a series of queries and with which I am having some
trouble.
My first query updates values in table 2 based on table 1.
My second query is a make-table query which essentially re-creates table 1.
My final step opens a form based on table 1.
When I run the macro, I get an error #3211, saying that the second query
cannot run to make (re-make) the table because that table is already in use.
It seems to me that perhaps the 1st query simply hasn't released the table
when the second query is being called, but I'm not sure how to slow down the
calling process or make it so the second step (query 2) isn't called in the
macro until the first one is completely done.
Any suggestions?
Thanks,
Emma
trouble.
My first query updates values in table 2 based on table 1.
My second query is a make-table query which essentially re-creates table 1.
My final step opens a form based on table 1.
When I run the macro, I get an error #3211, saying that the second query
cannot run to make (re-make) the table because that table is already in use.
It seems to me that perhaps the 1st query simply hasn't released the table
when the second query is being called, but I'm not sure how to slow down the
calling process or make it so the second step (query 2) isn't called in the
macro until the first one is completely done.
Any suggestions?
Thanks,
Emma