Update with ADO

[dclamp]

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

[kazuyabo]

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

[Hack]

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.

[si_the_geek]

Moved to Database Development forum

[GaryMazzone]

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:

conn.Execure strsql