Indexed 'error' when changing index in table

  • Thread starter Thread starter Mary Beth
  • Start date Start date
M

Mary Beth

I have imported data from an Excel spreadsheet into a new table into my
database. I have two different ID fields that cannot allow duplicates, so I
have changed the Indexed property in the new table to Yes (no duplicates).
However, when I try to save the table, I keep getting the following error
message. I am not sure how to handle this because I no duplicates are
allowed. Any help would be appreciated.

'The changes you requested to the table were not successful.....create
duplicates in the index, primary key..."
 
I have imported data from an Excel spreadsheet into a new table into my
database.  I have two different ID fields that cannot allow duplicates,so I
have changed the Indexed property in the new table to Yes (no duplicates)..  
However, when I try to save the table, I keep getting the following error
message.  I am not sure how to handle this because I no duplicates are
allowed.  Any help would be appreciated.

'The changes you requested to the table were not successful.....create
duplicates in the index, primary key..."

You can't add a unique index on a field/group of fields if there are
records in the table that would violate that key's uniqueness
constraint. Do a quick totals query on the fields in your index and
see if you get counts>1.
 
I have imported data from an Excel spreadsheet into a new table into my
database.  I have two different ID fields that cannot allow duplicates,so I
have changed the Indexed property in the new table to Yes (no duplicates)..  
However, when I try to save the table, I keep getting the following error
message.  I am not sure how to handle this because I no duplicates are
allowed.  Any help would be appreciated.

'The changes you requested to the table were not successful.....create
duplicates in the index, primary key..."

You can't add a unique index on a field/group of fields if there are
records in the table that would violate that key's uniqueness
constraint. Do a quick totals query on the fields in your index and
see if you get counts>1.
 
Back
Top