>>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

>
>Thanks for the info. I am not doing any updates via the disconnected resordset so that should not be a problem. But the recordset is actually a JOIN of two tables on the back end. Will this technique work in this situation?

No, I don't think so. I thought you mentioned you wanted to modify a primary key field and couldn't.