Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    visual basic 5.0 ado equivalent to Refresh

    I have an vb5.0 application that uses DAO and has linked access 97 tables. I need to upgrade to access 2000. Since there are problems with DAO and access 2000 I decided to change to ADO. What I would like to know is there an equivalent command to refresh in ADO. My data controls all use the refresh command.

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: visual basic 5.0 ado equivalent to Refresh

    There are two commands in the ADO recordset object that does what you say.

    rs.requery

    and

    and rs.resync

    Requery retreives the full recordset, resync just rescychronises with the database, either the current record or all records depending on your criteria.

    I would highly recommend this tool:

    http://www.geocities.com/scirocco_ha/DataControl.htm

    Originally posted by dgears
    I have an vb5.0 application that uses DAO and has linked access 97 tables. I need to upgrade to access 2000. Since there are problems with DAO and access 2000 I decided to change to ADO. What I would like to know is there an equivalent command to refresh in ADO. My data controls all use the refresh command.

    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
  •