Auto accept Make Table Query message

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

Guest

I have a series of Make Table queries that I run through a macro. These
queries basically take a snapshot of one table and refreshes the data on
another. I am planning on scheduling this macro to run during the night, but
how do I handle the "Table will be deleted" message while I am not here to
answer the question.

Any and all input wold be greatly appreciated.

Thanks,
 
Either set warnings off before running your existing code (and remember to
set them back on when you're done), or use the Execute method of either the
QueryDef object or the Database object to run the queries.
 
Add the SetWarning action to your Macro.
You will need one a the beginning of the macro with Warnings On set to no
and one at the end with Warnings On set to yes.
 
Back
Top