Need Help to delete records using 'recordset.Delete'

[felicia]

Hi All,

Below is my code to delete records:

adodcAllEntries.Recordset.MoveFirst

Do While (adodcAllEntries.Recordset.EOF = False)
If adodcAllEntries.Recordset.Fields(0) = selected_id Then
adodcAllEntries.Recordset.Delete
End If

adodcAllEntries.Recordset.MoveNext
Loop

I encountered error when the number of records to delete is >= 4 records.

Ther error is:
--------------------
Run-time error: '_2147467259 (80004005)':
Key column information is insufficient or incorrect. Too many rows were affected by update.


Can anyone help me to solve this?

[iburyak]

Is it possible that recordset had a duplicate value and it is unsure which to update?

Good Luck.

[Denburt]

What does this recordset look like? Why can't you just run an sql statement
"Delete * from YourTable Where selected_id = " & selected_id

Or something to that effect.

[felicia]

What does this recordset look like? Why can't you just run an sql statement
"Delete * from YourTable Where selected_id = " & selected_id

Or something to that effect.

HI, I am very new to VB. May I know how to run that sql statement?
i mean how to write the connection first?

All the while i am using ADODCcontrol.recordsource to connect to db and bind it with DataGrid control to retrieve data. This is easy for me because i no need to write the connection code.

FYI, i am using ODBC driver to connect to db.

Your prompt reply is very much appreciated

[Denburt]

What type of database are you using? Is it password protected? Located on a remote server?