How to Macro (Query) in Silent Mode

[Tom Lorenz]

I have a make table query that I want to run un-attended.
The query prompts for an "YES" to overwrite the existing
file. Is there anyway to not be prompted for the
overwrite?

 

[Ken Snell]

Just before you run the maketable query step, put in this step:

Action: SetWarnings
Expression: No

Then after the maketable query step:

Action: SetWarnings
Expression: Yes

 

[Tom]

-----Original Message-----
Just before you run the maketable query step, put in this step:

Action: SetWarnings
Expression: No

Then after the maketable query step:

Action: SetWarnings
Expression: Yes


--
Ken Snell
<MS ACCESS MVP>




.
Ken,

Thanks for the information, it worked great!

 

[Ken Snell]

You're welcome.

Thanks for the information, it worked great!