Soy de un lugar
|
Posted: 07/09/2005, 8:22 PM |
|
I have this problem...
for introducing one new employee in my table of access for update new employee getting this error
"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."
Please help my need this project...
|
|
|
wkempees
|
Posted: 07/12/2005, 2:03 AM |
|
The error message states it clearly.
first check your table employee, look for the keys on this table.
It should have at least a primary key (ususaly Id) defined as unique.
Check all other keys, if they are defined as unique then probably your
problem lies there.
If there are no other unique keys, then you are probably trying to add a
row with an Id value that already exists.
In a normal generated grid/record this problem would not occur unless
your database is defined with multiple unique keys.
Field validation is the way to go around these problems.
BUT as a rule a table has ONE unique primary key.
greetz,
Walter
|
|
|
|