I am trying to do a very basic edit of a record using ADO and VB 6 Enterprise:
Set objConn = New ADODB.Connection
Set objRS = New ADODB.Recordset
objRS.Open "select * from my_table", strConn
objRS("Field1") = MyValue
The problem is that when VB hits the objRS.Edit I get "method or data member not found."
Aside from using a SQL update (I need to mahually loop through the records and perform lots of calcs), what's the right way to do an edit with ADO. I've always used it before like that, but maybe it was DAO in the past.