Modify a primary key constraint (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

Modify a primary key if you want to change the column order, index name, clustered option, or fill factor.

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, right-click the table whose primary key you want to modify, and choose Indexes/Keys from the shortcut menu.
3. Select the primary key index from the Selected index list.
4. Type a new name in the Index name box. Make sure that your new name does not duplicate a name in the Selected index list.

The primary key is updated in the database when you save your database diagram.