How Do You Remove The Primary Key In A Database In Access 2003?
A primary key in a relational database uniquely identifies each record. To remove the primary key in Access 2003, you first must familiarize yourself with the program’s basic functionality. Read on to learn more. Open Access 2003. Select a database to open. Select the table with the primary key you want to remove. Find the primary key and click on the row selector. If the primary key includes many fields, click on any row selector in the key. Click the “Primary Key” icon in the toolbar. You have removed the key. Save the database to save your changes. Access will prompt you to select another primary key, which will default to an AutoNumber data field.
