Count of Affected Records

[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?

 

[Michel Walsh]

See the RecordsAffected property.



Vanderghast, Access MVP

 

[Guest]

RecordsAffected is available only in DAO and not in ADO?
Another reason to stick with DAO.

 

[Michel Walsh]

ADO Execute method got an (optional) argument filled with the number of
record affected, isn't it?



Vanderghast, Access MVP