I use a make-table query to import data from an ODBC source. Using VBA, I delete the old table and then use the following code to run the query.
Before running the query, I get a popup asking "You are about to run a make-table query that will modify data in your table... <Yes> <No>"
After running the query, I get another popup "You are about to paste 1202 row(s) into a new table... <Yes> <No>"
is there a way to avoid these popups so the queries create the tables silently?