Search notes:

Access Object Model: QueryDef.execute

dbFailOnError makes an execution of a statement throw an error if it didn't work.
recordsAffected returns the number of affected records of the most recent execute() call.

See also

Causing an Operation must use an updateable query Run-time error with an update statement and the execute method.
The execute method of the Database object.

Index