Don't Miss:
Back to School - Presented by Chevrolet

How to Remove the Primary Key in a Microsoft Access Database

Remove the primary key only if you're sure you won't need relationships between the tables in your database. Remember, you can only run queries on tables that have been joined in a relationship. These instructions are for Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

  • Microsoft Access
  1. 1

    If the primary key occurs in an existing relationship, first delete the relationship.

  2. 2

    Open the table in Design view.

  3. 3

    Select the row that contains the primary key by clicking on the Row Selector. This is the small box or field that occurs on the far left of a row.

  4. 4

    With the row selected, click on the Primary Key button from the toolbar, or select Primary Key from the Edit menu.

Tips & Warnings

  • Removing the primary key doesn't delete the fields, but only removes the primary key features.
  • print
  • favorite
Subscribe

Post a Comment

Comment
  • print
  • favorite

Related Ads

eHow delivers daily. Start your day with advice and inspiring ideas. Sign up for newsletters
eHow_eHow Technology and Electronics