>When an ADO client-side recordset is created including fields that are keys on the backend, ADO coerces the key fields in the client-side cursor to be not updatable. How can a client-side ADO recordset of this type be created in which all fields, including key fields, are updatable?
>
>Thnaks,
>Bill
You can create the disconnected recordset on the client side with the same structure and send that to the back-end. Now this would not play if you're doing updates via UpdateBatch.
oHeadRS = CreateObject("ADODB.Recordset")
With oHeadRS.Fields
.Append("FileName", adChar, 15)
.Append("SalesOrder", adChar, 10)
.Append("DateReceived", adChar, 20)
EndWith
oHeadRS.Open