Updateable ADO Disconnected Recordset

[Alleyopp]

I have created a querry in access and I have added a blank column..

What I want to do is create a recordset with the query then disconnect the recordset and update the blank field with data.. Then at the end I have to display all the info in the recordset.. I do not need the database but to gather the initial data..

I cant seem to get the recordset so it is updateable...

Set ohrstTotal = New ADODB.Recordset
sql = ""
sql = "Select * from qry_Quad_OverHead_Totals"
ohrstTotal.CursorLocation = adUseClient
ohrstTotal.CursorType = adOpenKeyset
ohrstTotal.LockType = adLockBatchOptimistic
ohrstTotal.Open sql, gcnn
'Disconnect the recordset
ohrstTotal.ActiveConnection = Nothing

Thanks
Alley

 

[cbsm]

Maybe if you use a class/collection ?

Create a class where each property would correspond to a field of the query + 1 for the empty one.
Populate a collection based on the recorset - and then you can do what you like with the data.

Would that be a solution for you ?