By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 1,783 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Finding index tables on an Access DB

P: n/a
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

May 18 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.