microsoft access course - Change of Primary Key

Resolved · Low Priority · Version Standard

Mon 4 Dec 2006, 15:59 Delegate Colin said...

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 ?.

Mon 4 Dec 2006, 16:22 Trainer David said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips