Thanks for the reply, but adOpenStatic does not work either. From further research into Access Help ("Recordset Property"), it looks like ADO does not play well with Access MDBs and/or I am just not using the right combination of properties/methods to get a temporary updateable scratch Recordset. The record locking should really not be an issue since I only want to use the Recordset to hold temporary processed data -- changing the values only in the Recordset itself, not in the underlying source table(s). The backend is AS400 DB accessed via linked ODBC in Access.

For now, I will just use an Access table to hold my temporary processing so I can get the necessary changes made. If I get the chance, I'll circle back and try to figure out how to imitate VFP updateable Cursors in VB/Access.

Scott

>adOpenForwardOnly would give you a read-only RS. Try using adOpenStatic and see if that solves the problem. Also, if you will be inserting or updating several rows at a time you might want to try adLockBatchOptimistic (or something like that) and send the updates with rs.UpdateBatch.
>
>HTH
>
>PS What is the backend database?
>