Finding an index in an Access DB

[jhall]

At some point an index has been added to a table in my Access DB that
does not allow duplicates. I can't see where I ever put an index on
this field.

But, when I tried to add 2nd records with a duplicate value in the 2nd
field (not the primary key field) I get an error saying "The changes
you requested to the table were unsuccessful because they would create
duplicate values in the index, primary key or relationship."


When I open the table in design mode the "Indexed" property on the
field says "No"


1. How do I find the name of this index?
2. Can I delete it through the Access menus or do I use SQL statements?



Best regards,
John

 

[Douglas J Steele]

With the table open in Design view, select Indexes from the View menu.