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.

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