Show All

Remove the primary key (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

1. If the primary key is used in a relationship, you must delete the relationship before you can remove the primary key.

   How?

   1. Close any tables you have open. You can't delete relationships between open tables.
   2. Press F11 to switch to the Database window.
   3. Click Relationships on the toolbar.
   4. If the tables whose relationship you want to delete aren't displayed, click Show Table on the toolbar and double-click each table you want to add. Then click Close.
   5. Click the relationship line for the relationship you want to delete (the line will turn bold when it's selected), and then press the DELETE key.
2. Open the table in Design view.
3. Click the row selector for the current primary key and then click Primary Key on the toolbar.

Note  This procedure doesn't delete the field or fields that are designated as the primary key; it simply removes the primary key features from the table.