Change an access Primary key with relationships
Posted
by DiegoMaK
on Stack Overflow
See other posts from Stack Overflow
or by DiegoMaK
Published on 2010-03-30T15:20:24Z
Indexed on
2010/03/30
15:23 UTC
Read the original article
Hit count: 357
I have a database in access 2007 accdb extension , there are more or less 30-40 tables with related primary key "local_number". it is a text primary key with 10 lenght.
How can I change the length of this primary key to 30 WITHOUT delete previosly all the 30 relationship.
2,A similar question. I need add a compose primary key to my PK "local_number". I need Add a "Date" as composed PK. Then access just allow this if I first delete all relationships.
How can Avoid this warning and change my PK ignoring this message.
© Stack Overflow or respective owner