Search code examples
ms-access

Microsoft Access: Manually Changing size of text field that is primary key in 3 relationships


I have a tiny old Microsoft Access Database with customerID that is text size 6. customerID is the primary key of 3 tables. If I want to change this to 9, can I safely manually delete the relationships, change the size to 9. Do I do this in all tables? Then recreate the relationship?


Solution

  • Yes you can do so safely. Just record every deleted relationship that you're gonna delete so you won't forget to recreate it.