How to Remove the Primary Key in a Microsoft Access Database

Print this article

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.

Instructions

Microsoft Access

Suggest Edits

- 1
  
  If the primary key occurs in an existing relationship, first delete the relationship.
- 2
  
  Open the table in Design view.
- 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
  
  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.

Suggest item

Comments

How to Make a Query Primary Key in Access
A primary key uniquely identifies a row of data in a relational database table. It is important to specify a primary key...
How to Remove Primary Key SQL
Primary keys are an important part of a table design. When redesigning tables, there may come a time when a primary key...
How to Drop the Primary Key in Access
Knowing how to remove a primary key from a field using Microsoft Office Access can save you time when automating database processes....
How to Set or Change the Primary Key in an Access 2003 Database
The Access application uses the primary key to identify each item in a database table. When you set or change the key,...
How to Use a Query to Delete a Record in a Table in Access
Microsoft Access allows you to delete one or more records or tables from your database with the Delete statement. You can delete...
How to Set or Change the Primary Key in a Microsoft Access Database
Before setting or changing the primary key in a Microsoft Access database, it's important to understand that Microsoft Access is going to...
How to Update the Primary Key Field
Open Microsoft Access 2007. Click the round button in the upper, left of the screen containing the Windows log and choose "Open."...
The Purpose of the Primary Key in Access
Microsoft Access uses primary keys to uniquely identify each record in a table. The database administrator defines a primary key when he...
How to Use GUIDs As Primary Key
Primary keys are used in databases to uniquely identify a row of data. Traditionally, a given table will use incrementing integers (1,...
How to Access the Multiple Primary Key
Microsoft Access uses primary keys to identify unique information in your database. This information is helpful when creating relationships between tables. Examples...
How to Make Table Query Primary Key in Access
You can use a "select query" in Microsoft Access to choose specific fields to be displayed from a table. A simple select...
How to Change a Primary Key
The purpose of a primary key is to have one and only one set of data in a table with a unique...
How Do I Create a Custom Primary Key in Microsoft Access?
Use primary keys in Microsoft Access as unique fields within your table. By default, Access uses an index number field as the...
What Is a Microsoft Access Primary Key?
Microsoft Access is part of the Microsoft Office productivity suite. Access is one of the few programs that allows a user to...
How to Drop a Database Table Only If It Already Exists
If you use a database for long enough, you will probably run into a situation where you want to drop a table...
How to Set or Change the Primary Key in a Microsoft Access Database
Primary keys are unique record identifiers that MS Access uses when retrieving information for a query or a report. With primary keys,...
How to Access a UUID Primary Key
A universal unique ID, or UUID, is a number contained in a SQL Server database that appends a alphanumeric string to a...

How to Remove the Primary Key in a Microsoft Access Database

Instructions

Things You'll Need

Tips & Warnings

Related Searches

Comments

You May Also Like

Related Ads

Tech Know: Improve Your Digital Life With Tech Tips

Related Articles & Videos