ADO Errors collection

[Jimbob]

I'm getting a very useful message from the ADO Errors Collection: -

err.number is -2147217887
err.description is a very helpful 'Errors occurred'

has anyone else come across this one?

it doesnt happen at a particular line, but it does happen within a certain part of my code. the code in question follows this type of structure: -

with MyClassInstance.MyRs
!Field1 = txt1
!Field2 = txt2
.update
end with

I don't want to execute an UPDATE Query, as there are loads of fields in the set and the sql would be about 10 lines long!!

as I said before, the error doesn't happen on the same line each time, or even within a certain record within the set. I've done the obvious checks (make sure not trying to make it null, etc) but to no avail.

Does anyone out there know anything about this one, as it's making me tear out what little hair i've got left...

[Mongo]

I couldn't find your specific error code in anything I have... which isn't saying much
but one of these MSDN articles may hold a hint or two: Q1926652, Q195491, Q189220.
Hope they help.

[Clunietp]

enumerate thru the Errors collection to get the description of the error