Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    44

    Unanswered: Update Statement Question

    I run an update statement and use a db.execute (updatestatementstring) code. How Can i check to see if it did an update? I know in Visual Basic you can run a nonquery and it will return how many records it updated etc.

    Thanks.
    Last edited by tvb2727; 04-26-10 at 06:37.

  2. #2
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    I found this in the Help section in Access.

    Use the RecordsAffected property of the Connection, Database, or QueryDef object to determine the number of records affected by the most recent Execute method. For example, RecordsAffected contains the number of records deleted, updated, or inserted when executing an action query. When you use the Execute method to run a query, the RecordsAffected property of the QueryDef object is set to the number of records affected.


    C

  3. #3
    Join Date
    Jan 2010
    Posts
    44
    Thats what I was looking for. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •