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?
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
 
S

Steve Schapel

Steve,

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