E
esharris
I am trying to find an index on a table.
I inherited a MS Access 2003 database containing a table. If I add a row to
that table whose XXX field value is not unique to that table, I get the
following error message.
"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 duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again."
The XXX fields is not the primary key; I checked the table's design view. So
I assume the problem is in some index.
How do I find the related index?
Thank You.
I inherited a MS Access 2003 database containing a table. If I add a row to
that table whose XXX field value is not unique to that table, I get the
following error message.
"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 duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again."
The XXX fields is not the primary key; I checked the table's design view. So
I assume the problem is in some index.
How do I find the related index?
Thank You.