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.