"Multiple-step operation generated errors"

  • Thread starter Thread starter Michael Daly
  • Start date Start date
M

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
 
FYI

Turns out I was trying to insert a record whose unique
key matched a record that already existed in the database
table.
 
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.
 
Back
Top