Eliminate Popup for Make query

[Cam]

Hello,

Is it possible to remove the pop up message to ask you whether it will
overwrite your existing data in the table whenever a Make-Query is executed?
Thanks

 

[Allen Browne]

You can SetWarnings to No, but it would be better to use the Execute method
to fire off the query.

Details in:
Action queries: suppressing dialogs, while knowing result
at:
http://allenbrowne.com/ser-60.html

 

[Jeff Boyce]

Cam

If you'll describe a bit more specifically what you're using Make Table
query to accomplish (i.e., what's the underlying business need for a new
table?), folks here may be able to offer alternate approaches...

Regards

Jeff Boyce
Microsoft Office/Access MVP