How can I change the primary key in Access 2007

[Guest]

I need to remove the primary KEY from a field in an Access 2007 database. I
have followed the instructions from the "Help" facility, but it is not
appropriate as the stages indicated are not what I actually get.

Very frustrating.

 

[Guest]

Why do you need to remove the primary key?
Do you want to remove or replace?
Do you have tables with a relations using the primary key to foreign key?

Backup the database, open the table in design view, select the field, click
on the icon that looks like a yellow key, and save the table.