error message

M

marwan hefnawy

do any one know what is the possible reason for the error message
"key column information is insuffecient or incorrect.Too many rows were
affected by update"
It appears to me when I try to update or insert data through the Access form
in the SQL server SP3 database.
But after I click OK and close the form and re-open it I found that the
records were inserted (or updated).
my SQL database has a PK which is an identity number column.
It has also three triggers and a UDF.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top