How do I run a macro to run several querries?

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

Guest

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?
 
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?
Click to expand...

As the first line of the macro

SetWarnings to No

then at the end of the macro,

SetWarnings back to Yes

Tom Lake
 
Steve,

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