I have a ADODB.Recordset in my Access 2002 project. I've been able to successfully add fields to the record set. According the the MS Access help files, I now must update the recordset to get the field additions to "stick." For example, the code below shows how the Access help files say to append fields to a ADO recordset.
Expand|Select|Wrap|Line Numbers
- dim ADO_RS as ADODB.Recordset
- set ADO_RS = (some other ADODB recordset)
- ADO_RS.Close
- ADO_RS.Fields.Append (Name), (Type), (Size)
- ADO_RS.Fields.Update
The Access help file says that "Update" is a valid method for the ADODB.Fields object, but the VB editor says it isn't. Even the Object Browser in the VB editor doesn't list "Update" and a valid object.
Is there a reference I'm missing? How can I get the field additions to the ADODB.Recordset to "stick"?
I've tried running my code without the update. When I put a watch on the recordset, I can see my fields getting added. But as soon as I use the Open method to begin adding data to the recordset, the fields I added disappear.
Thanks for your time and help,
Scott