Change the Primary Key

Prev Show Me Step-By-Step Next

Get Ready
Display the table containing the primary key you want to change in Design view. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.
Be sure the table is not involved in any relationships requiring the primary key.
Decide which field will be the new primary key.

Begin
Select the name of the new primary key in the Field Name column.
Click the button.