Openquery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few append queries that I want to run with a macro. I have done
this many times before and never got the results I am now. Which is the
queries all stay open or open the tables they are appending to. I have put
in a setwarning to no but still get all the tables open at the completion of
each openquery. What could I be doing wrong? Thanks
 
I have just investigated further and the problem is my append queries come
from a select queries which is what are opening and staying open even though
they are not in the macro. Is this normal and is there a way to stop this?
Thanks
 
Akrt48,

No this is not normal. Please check that the only queries you have an
OpenQuery action for in your macro are the Append Queries.
 
Steve; Other than a set warning at the beginning and then three delete
queries to clear the tables affected it then becomes my append queries. But
as I say these queries are predicated on a couple of select queries, which
are the ones opening and staying open. I don't understand why?
 
Back
Top