Change Recordset Field Attribute propertyy

[DeafBug]

How do you change the Long value of the Attribute property? I have a recordset that is the returning recordset from a stored procedure. I have another recordset that collects all the record. For each call to the stored procedure, the returned recordset gets appended (by AddNew and assigning each field Value) to the other recordset. For some reason, one of the Fields is set to Read-Only. It has a value of 112 in the Attribute property. I want to change it to read/write so I can assign the value of the field in the recordset that accummulates.

[Twodogs]

If the field is part of the primary key, you won't be able to change it. What you could do however, if you are only displaying, rather than actually changing the records in the db, is to declare an array of user-defined type, put the records into there changing the values as required.