Trouble Updating table with ADO 1

[lbrechler]

Having trouble connection to an Access table to update a specific record. Here's what I'm trying (most recently):
Set rstUser= New ADODB.Recordset
SQLst = "SELECT * FROM USER where PID=2"
rstUser.Open SQLst

If rstUser.EOF Then
MsgBox ("Add New User&quot
rstUser.AddNew
Else
MsgBox ("Update Existing User&quot
rstUser.Edit
End If
I get an error that says "Method or data member not found". I've tried ".EditMode" but that isn't it either.

Any suggestions?

Thanks in advance,
~L

 

[dpaulson]

ADO does not have an edit. You simply issue an .update when you have updated the fields. Your major problem is that the ado recordest default is read-only.

rstUser.Open SQLst,yourconnection, adOpenKeyset, adLockOptimistic, adCmdText

This should get you an updateable recordset.
David Paulson