ERROR 3022 duplicate values in the primary key, index or relationship 1

[lui]

I've put together my first access database. When I try to enter a record I get the error 3022 message.<br>
I'm not sure where to start to narrow down the specific problem. Any comments or suggestions are<br>
welcome!

 

[DougP]

First of all the definition of a Primary key is a unique key for every record in the table.<br>
The main reason is it searches very fast and it allows the Relationship wizard to create automatic relationships between tables among other things.<br>
So you can't add another record which has the exact same value as another item in the table.<br>
Do you have Access '97 or 2000 installed on your computer?<br>
It is a great troubleshooting tool to look at your data.<br>
So go to Access open the table you are trying to add a record and see if the Primary key has the same value as the you are adding.<br>
If you don't know which is the Primary key open the table in Design view and look in the upper left hand part of the fields definitions it will be the field or fields that have a Key in the gray square.<br>
Most Primary keys are at the top they are usually the first field added to a table.<br>
<br>
Hope this Helps<br>
DougP<br>

 

[lui]

I'm using Access97.<br>
No, the Primary Key doesn't have the same value as what I'm entering.<br>
I appreciate the explaination though.

 

[lui]

Pardon me! Yes I was entering the same value in my primary key.<br>
Thanks for the direction!<br>
LUI