Need count of updates after UPDATE query

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

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

strSQL = "UPDATE ..."
currentproject.connection.execute strSQL
 
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.
 
You must log in or register to reply here.

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

Update query issue 0
Update Query Problem 2
SQL Syntax Error - UPDATE command 1
Select count(*) does not work from code 12
Append query works, but doesn't... 2
Run-time error 91... 2
query on query 1
Error: can not execute a select query 3

Back
Top