Supress Confirmation Window for Automated Tasks

[Guest]

I want to setup an automated task that runs an update query to a linked table
in an autoexec macro. A confirmation window opens "You won't be able to undo
the changes....." and halts the macro. Is there a setting or option to
supress this confirmation window?

Thanks

 

[Douglas J. Steele]

Either set warnings off before running the query (and set back on after it's
run), or else use the Execute method of the query.