Count of Affected Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Databases processing SQL return a count of affected records. For action
queries this is useful information. An update may be syntactically correct
and be processed by the database, but will affect no records and a lot of
records. Is there any way to retrieve this record count in Access VBA?
 
RecordsAffected is available only in DAO and not in ADO?
Another reason to stick with DAO.
 
ADO Execute method got an (optional) argument filled with the number of
record affected, isn't it?



Vanderghast, Access MVP
 
Back
Top