Need count of updates after UPDATE query

M

mscertified

Is there any way to get the count of updates after running this?

strSQL = "UPDATE ..."
currentproject.connection.execute strSQL
 
F

fredg

Is there any way to get the count of updates after running this?

strSQL = "UPDATE ..."
currentproject.connection.execute strSQL
Click to expand...

Look up the RecordAffected property in VBA help.
 
Top