Error -2147217887 (80040e21) when deleting a recordset.
Posted on 2005-05-02
Hi, guys, I'm working with SQL7, VB6 and ADO in a program. I have a form where I do the update of a master table, which has two more tables related in a father-child-grand child structure, ok ? I have a problem when deleting a recordset from the master table. When doing the deletion process, first are deleted the records from the child and the grand child tables, and at last master recordset. The error occurs in the delete command, the error message is as follows:
Run-time error -2147217887 (80040e21)
Multiple-step operation generated errors. Check each status value.
I've tested many things, but the error still go on. First I changed the opening mode of the recordsets as Keyset or Dynamic mode. Then I changed the way to delete the recordsets from the tables, from a SQL command to a simple VB delete command. Well, if you need I can send you same of the code to help you find out the problem, ok ?