Primary key in MS Access VS MS ADP

[dwight1]

Hi All,

I have a table in MS Access that has duplicate primary keys, the properties of the table is set to Indexed-NO.

I have imported the same table in MS ADP, it does not allow me to have duplicate primary keys. If i change the property to Indexed-NO or Indexed-(Yes Duplicates)it saves the table but does not allow the primary key status to the field/column.


Can any one please suggest how to cross this hurdle?

This table is linked to many other tables in the subsequent queries based on the defined primary key.

Any help is appreciated.

Dwight

 

[cmmrfrds]

Add an auto identity column to the table as the primary key.

You could add a clustered index with the concatenated fields as unique values.