Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Fields.Append "test1", adNumeric
rs(0).Value = 1
On the line that sets the value for the field I get the error : "Multiple-step operation generated errors. Check each status value."
I am using ADO 2.7.
This snippet is part of a larger project, and I DO NOT have the ability to change to one of the other datatypes such as adCurrency.
Any suggestions on how to stop the error would be greatly appreciated.