I can not delete a record in a SQL server table. I did an insert into the table using VB. I inserted this record 4 times into the Table. I can delete other records in this table but not the ones I inserted in. The error I get is as follows:

Key Column information is insufficient or incorrect. To many rows were affected by update.

I have tried running the SQL Query analizer and used the following code

Delete From tTable
Where AcctNum = "The Account Number"

It returns and says successful but the records are still there????