Access stops me from increasing the size of a key field

[Persist]

Access stops me from increasing the size of a key field

Table tTrades
. Key field: idTrade: auto-number
. Field: Code: Text 10 characters

Table tData
. Key field: Code: Text 10 characters

I get an error message when I try to change either of these Code fields from size 10 to 16 characters

Error message “you cannot change the data type of field size. It is part of one or more relationships. Te change the data type of this field, first delete its relationships in the relationships window.

I deleted all relationships in the relationships window


But I still get the same error message.

If I click on relationship window > "All realtionships", Access reproduces all my relationships in the relationship window. Somehow it knows them. I deleted them all again and saved.
But I still get the same error message.

I have a form ftTrades which generates automatically when I click on table tTrade and create a form
I deleted this form ftTrades
But I still get the same error message.

Any ideas on how I can increase the size of this field

[tanvi]

Hello Persist,

It looks like you have missed some relationships. Verify that you have selected all the relationships for delete. Click on the 'Show All' button to verify.
If it is a split database then deleting relationships in the front-end does not reflect on the actual relationships, so you need to delete it in the back-end also.

[June7]

I made a copy of my db. Removed all reports, forms, queries, relationships, deleted records, removed lookups from table, ran compact and repair - still get this message. So the issue is not really relationships - MS is known to give messages that are not accurate for an issue.

In one table I remove the PK designation but still could not change the field size. In another table would not let me remove the PK designation.

I tried importing tables to a new db, same issue.

Apparently, changing properties of a PK field is not easy.

Went back to original db. Made copy of table. Fixed the PK field in copy. Deleted the original table. Renamed copy. Everything works.

[Persist]

I copied the whole database Mydb01 to Mtdb02 first
So far I have not needed this backup

Copied tData to tData02
Changed the length of PK Code in tData02

Copied table tTrades to tTrades02
Changed the length of Code in tTrades02

Renamed tData02 to tData
Access warned me that all relationships would be deleted
I said to do it
I got a fright.
All the queries and forms shown under tData were no longer under tData
They were there but not under tData
I opened each one in design and saved it. It moved itself to under tData.

Same happened for tTrades02

I think I have made the change I wanted
Thanks