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