"Multiple-step operation generated errors"

[Michael Daly]

Hi,

I am using ADO 2.5 in Excel XP to build a recordset from
the rows in my worksheet, then update a DB2 database with
the recordset's contents. This is something I've been
able to accomplish before in other workbooks, but not
this time.

When my code attempts to execute the ".update" method, I
receive the following error.

Error: -2147217887
Description: Multiple-step operation generated errors.
Check each status value.

This is a new one on me, and I have no idea where to
begin. Any ideas?

Thanks,
Michael

 

[Michael Daly]

FYI

Turns out I was trying to insert a record whose unique
key matched a record that already existed in the database
table.

 

[onedaywhen]

The error is the generated in a variety of situations. I most often
see this when an amended recordset value is of the wrong data type for
the column e.g. trying to update a not null column with a null. As the
message says, check the values you are trying to update the database
with to ensure they are valid.