The problem is there are two or more records that are identical. 
ADO is confused as to which on to delete. This can happen in a update also..


Hope this helps..
Mitch Spruill
Mannatec, Inc.


-----Original Message-----
From: Shiny Mathew [mailto:smathew@i...]
Sent: Thursday, August 16, 2001 02:06 PM
To: professional vb
Subject: [pro_vb] Multiple-Step Operation Generated Errors. Check Status
value


Hi,

I got this error from my application while deleteing a record:

    Run-time error '-2147217887(80040e21)' Check each status value.

I am using ADO Data Control(SQL SERVER- OLEDB) and its properties are as
follows:

    BOF Action = adDoMoveFirst
    CursorLocation = adUseClient
    CursorType = adOpenStatic
    EOFAction = adDoMoveLast
    LockType = adLockOptimistic
    Mode = adModeReadWrite

    Going through all the records in a table
    One Recrod per Screen

I am getting the error on the following condition:

When the "Delete" button is clicked the following command is executed
which
resulted in the above error:

    adoCustomer.Recordset.Delete


Please Help, if you came across the same problem.

Thank you,

Shiny Mathew