>I'm using a microsoft visual foxpro driver, i want to know how to edit a record using ADO. anybody help.
There is no Edit method like we were used to with DAO. You now simply set your fields to new value and use the Update method.
rs!field1 = 1
rs!field2 = "Good morning"
rs.update
Be sure that your LockType is different than read only before opening the recordset.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com