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?
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement