Colin has attended:
Access Introduction course
Access Advanced course
Access Intermediate course
Excel VBA Intro Intermediate course
Change of Primary Key
If after setting up a Database , I wished to amend the Primary key - would I have to undo all the relationships first ?.
RE: 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
