Changing Field Size in Linked Table

[Steven Manesh]

Changing the size of a text field in a table linked to other tables

Greetings,
There are several linked tables in my DB project, which runs without any problem. However, I need to change the size of a text field from 40 to i.e. 60 characters. Access does not allow me to do so, stating “the property of this field cannot be changed because this table is linked to some others.”
I must increase the size of this particular text filed in a table without redefining all my tables. Your help is greatly appreciated. Thank you.
Sincerely,
Steven

 

[R6Flyer]

Change the property in the actual database where the table resides - as the table is linked it will update automatically.

 

[theprez]

Sorry to tell you this, but if the field you need to change is a field that links the table (has a relationship with) then you will have to delete the relationship, change the field (probably on all related tables with the corresponding linked field) and then re-establish the relationship.

If the field is not used to link or build relationships with other tables, you will be able to do with you want following the instructions of R6Flyer, but this is only relevant if you have backend tables database linked to a front end database.

 

[Steven Manesh]

Change the property in the actual database where the table resides - as the table is linked it will update automatically.

Thank you.

 

[Steven Manesh]

Sorry to tell you this, but if the field you need to change is a field that links the table (has a relationship with) then you will have to delete the relationship, change the field (probably on all related tables with the corresponding linked field) and then re-establish the relationship.

If the field is not used to link or build relationships with other tables, you will be able to do with you want following the instructions of R6Flyer, but this is only relevant if you have backend tables database linked to a front end database.

Thank you.