runSQL is used to execute an insert statement, by default, Access pops up a message box with a You are about to append … row(s) message:
doCmd.setWarnings false must be executed beforehand. currentDB.execute "alter table tab_foo add column col_bar int"
runSQL cannot be used to create views.