remove about to delete before macro is run

[Pammy]

Is there a way to run a macro to delete a table and then append updated
information without it prompting me that it is about to delete and then to
prompt that it is about to append? I do not want to see this if possible.

Thanks,

 

[wesjr]

You can use the Set Warnings to false before your query commands then set it
back to true after the commands.
Hope this helps.
wf

 

[Steve Schapel]

Pammy,

Add a SetWarnings/No action to your macro, before the first of your
OpenQuery actions.