Update Errors

[Jesse]

I have created a web application that uses Access 2000 and ASPX. It
usually updates the database on the first change. After which it offers
either a concurrency error, or
"The changes you requested to the table were not successful because
they would create duplicate values in the index, primary key, or
relationship. Change the data in the field or fields that contain
duplicate data, remove the index, or redefine the index to permit
duplicate entries and try again."
How do I trace this problem. It's driving me crazy. I've stepped
through the entire update nearly 50 times and I have discovered nothing.
How should I go about debugging this?

Jesse Naiman

 

[Val Mazur]

Hi,

That error means that you have some primary key in your table and you try to
insert new records into that table, which already has those values in it.
Primary key field(s) cannot contain any duplicated values. Just check which
values you insert into that PK field or fields