Does anyone know what I have to do to get an ADO data control's
recordset to save to an oracle database. I am used to RDOs and when I
pass values to the recordset it keeps falling over when I  .update. I
have made sure the properties Cursortype is 1- adOpenKeyset and that
Mode is read write etc. I would normally use a .edit command but it
looks like you don't have to use this with ADO.recordsets   Please HELP
I have
asked loads of colleagues.

Not sure about the control as I haven't yet used it but I have done it in code
for what it's worth:

Set cn = New ADODB.Connection
With cn
        .ConnectionTimeout = 3
        .CursorLocation = adUseClient
End With
cn.Open "Provider=MSDAORA;Data Source=[Your Data Source];User Id=[Your User
ID];Password=[Your Password];"

Set rs= New ADODB.Recordset
rs "Select * from ATable", cn, OpenKeyset, adLockOptimistic

rs.addnew
rs!Field1=text1.text
rs!Field2=text2.text
rs.update

Tim H.

oops
rs.open "Select.....

not

rs "Select..."

Tim H.