Is there any way to disable the confirmation message/warning that displays, when a Make-Table query deletes an existing table.

This dialog box shows up and basically makes my macro stagnant.

You can add a setwarnings off before you run the query and then a setwarnings on after the query. For my own sanity, I also set the hourglass on when I've turned warnings off and then back off when I've turned the warnings back on. That way I always know that the warnings came back on (this is critical if you do any development in the database).