error message on Access

H

hyperkink

When I open an existing database and open a file, it says" the changes you
requested to the table were not successfully because they would create
duplicate value in the index, primary key...." Could you please tell me
what's wrong? and how to fix it?
 
D

Daniel Pineault

This usually happens when the database tries to save a newly created/modified
entry. What it is stating is that a record already exists with the same
Primary Key.

For Instance, if I setup up my table to use my last name as a unique value
primary key (therefore not allowing duplicates) and I enter my name. Then
later I go to enter my name a second time, I will recieve this message.

According to you setup/database the information you are trying to commit
already exists. As far as helping you it is rather difficult without knowing
more about your forms and tables.

Did you design the db? You need to determine what field is causing the
problem. Either it is a user issue or a design issue. Both can typically
easily be addressed.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.
 
Top