Error in update data ...

[Vincent81]

I use SQL server 2000 for my database, and for conection i use ADO
but i get error when i want to save data? like this
"Key column information is insufficent or incorrect. Too many rows were affected by update. "

this my code

Private Sub Command8_Click()
If add = True Then
rs.AddNew
Else
rs.UpdateBatch
End If
save_data
rs.Update
rs.MoveFirst
DataGrid1.Refresh
Call load_form
first_button
colour_save_text
lock_text
End Sub

maybe someone can help me?
thanks

 

[Transcend]

What are you using for your front end?
You realise this is an Access forum?

Transcend