microsoft access course - Change of Primary Key

Hi Colin

Yes you will need to remove all of the table relationships before you alter the primary key in Microsoft Access. This is vital as the primary key is used to link the tables within Microsoft Access and any change to the primary key field will effect the relationships that link the tables with MS Access. So if you remove the table relationships then you remove all the links between the Access database tables. Once all of the links are removed the primary key fields can be changed.

Hope this helps

David