Error for saving 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

 

[smin]

Sounds like you are trying to update the table that does not have primary key.

 

[tlbroadbent]

The table must have a unique constraint (primary key or unique index) or timestamp column so rows can be identified.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Vincent81]

thanks for the answer