Pre-Authorization of Make Table with Multiple Queued Queries

[Wormling]

Sorry if this has been asked and answered elsewhere - I assume I'm not the first to encounter this problem, but haven't had luck finding the answer either here or with google search.

I have several queries that make local tables from linked odbc tables. I am trying to get them to all update overnight as it takes ~3 hours per table, and this kills productivity having to sacrifice a day each week to updating my local tables. Currently, thanks to others' help and googling, I have the following setup:

Sub RunAllQueriesMacro()
DoCmd.OpenQuery "Query-MakeLocalA"
DoEvents
DoCmd.OpenQuery "Query-MakeLocalB"
DoEvents
End Sub

Example shortened to two as the command repeats, only changing query name. This works fine except that each and every single query will pause, have a popup saying that it will modify data, and ask for approval. Having to manually approve each query before it runs defeats the purpose of this macro. Is there any way to pre-approve these queries to run and make local tables?

Thank you for your time and any and all assistance.

[pbaldy]

Check out SetWarnings.

[Wormling]

Thank you kindly pbadly for the quick reply. That does appear to be exactly what I was looking for. Will try it out tonight.

[pbaldy]

Happy to help and welcome to the site by the way! Don't forget to turn warnings back on after running all the queries. Also, personally I'd be more likely to empty/populate existing tables rather than making new ones every time.