Update with ADO

How do you update with ADO. I can add, but i dont know how to update...

Just like when your deleting a record the only Deference it instead of rs.DELETE used rs.UPDATE

If you are using ADO Code (I hope) rather than an ADODC bound control, then you would use the .Execute method of the connection object to perform action queries like UPDATE, DELETE, INSERT, etc.

Moved to Database Development forum

Code:

---

strsql = "Update table name here Set field name here = value here Where Key field here (PK) = a value here to point to the required record

---

then use connection execute method:

VB Code:

conn.Execure strsql