Remove confirmations for Action Queries
Whenever you run an Action Query (i.e. a Delete, Update or Append Query) Access by default asks you to confirm this action. If you want the query to run automatically, then you will need to do one of two things. Either:
The other option is to use the Execute method on a SQL string, and then use Transactions, as well as error trapping.
Copyright & Disclaimer