How do I run a macro to run several querries?

S

Steve A

I am trying to run a macro that will run several make table querries but it
will stop because it will always ask for permission to change or delete the
table that it is creating. How do I get around this problem?
 
T

Tom Lake

Steve A said:
I am trying to run a macro that will run several make table querries but it
will stop because it will always ask for permission to change or delete
the
table that it is creating. How do I get around this problem?

As the first line of the macro

SetWarnings to No

then at the end of the macro,

SetWarnings back to Yes

Tom Lake
 
S

Steve Schapel

Steve,

Put a SetWarnings/No action in the macro before the first of the
OpenQuery actions.
 

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

Top