Openquery

A

Akrt48

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
 
A

Akrt48

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
 
S

Steve Schapel

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.
 
A

Akrt48

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controlling flow of actions 2
Append Queries in a Macro 6
using If,then, else statement in a macro 2
My Visio2019 Keep Crashed when open the program 0
Append query works in DB view not in macro 2
Turning off action query confirmation messages 1
Run Macros to update data 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top