RecordsAffected Property
Returns the number of records affected by the most recently invoked Execute method.
Return Values
The return value is a Long from 0 to the number of records affected by the most recently invoked Execute method on either a Database or QueryDef object.
Remarks
When you use the Execute method to run an action query from a QueryDef object, the RecordsAffected property will contain the number of records deleted, updated, or inserted.
When you use RecordsAffected in an ODBCDirect workspace, it will not return a useful value from an SQL DROP TABLE action query.