CODEWITHSUNDEEP
ms-access
SpecialEd
SpecialEd

Reputation: 495

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?

Upvotes: 1

Views: 74

Answers (1)

Toni
Toni

Reputation: 1585

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

Upvotes: 2

Related Questions