count the update values(rows)

[alazarou]

Hi all,

i am stuck on this... how could i count the update values(rows) from an update query without using a select query to count the data .
I use a ADODB.Command to run the update query in an Access DB.

Thanks,
@ndy

[RhinoBull]

ADO Command and Connection object's Execute method has optional argument [RecordsAffected] so you may pass an Integer variable and after execute is completed - read it back.

adoConnection.Execute "test", intRecordsAffected
MsgBox intRecordsAffected

or ...

adoCommand.Execute intRecordsAffected, "parameter"
MsgBox intRecordsAffected