Count of Affected Records

S

Steve McLeod

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

Steve McLeod

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

Michel Walsh

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



Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Pipe character in query in VB6 app 11
Select Top with aggregate function 1
Record count 2
counting records 3
Counting records in a query 9
record COUNT() query not working in VBA code 3

Top