How can I change the primary key in Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top