ERROR MESSAGE- Duplicate Value in the Index

[kinselas]

Could someone please help...What does this all mean.

"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 the duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

 

[zerosandones]

This one's easy to debug.

Open up your table in design view then select "Indexes" from the "View" pulldown menu.

If your table has a primary key, it will be annotated with a key symbol immediately beside the associated index name. If the primary key consists of more than one field, each of those fields will have a key symbol beside it. Take note of all the "Field Names" which are part of that primary key.

The next possible source is that you have a unique index ... this is different than a primary key, but, prevents duplication as do primary keys.

To verify if any unique indexes exist, view indexes for your table and click on each row with an "Index name" (except for the primary key you already noted in the step above). If the field entitled "Unique" has a value of "Yes", write down that field name and any other field names immediately below the current record that has a blank "Index Name" ... that means that the next field or fields are part of the index which did have and "Index name". The field or fields for each of these indexed names form a unique index.

Once you understand which combinations of fields form primary or unique indexes, you'll understand exactly why the new record you're trying to enter from your form is violating your tables index rules and generating the duplicate notification.

Does this help?

00001111s

 

[kinselas]

Thank you for your help ZEROANDDONES .It Works

 

[darley]

I am having the same error. In Access 2000 (SP3) and I cannot find the "INDEXES" area of the VIEWS menu. Anyone else know where to find this info?

 

[Garridon]

Please note that in some cases, this error message can also signal a corrupted index. If it recurs again, this FAQ tells you how to correct a corrupted index.

http://www.tek-tips.com/faqs.cfm?spid=700&sfid=1895&CFID=1870811&CFTOKEN=1801295