I'm using an ADODB Recordset(Microsoft ActiveX Data Objects 2.1) and am having problems with the .addnew method. When I try and add a new record passing the two neccesary arrays (fields and values) I get an error saying :
"ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application".
However, the fields passed match those in the recordset exactly. What's going on? Any help appreciated.....