Access 2000 - Property Field Size

[Al Tidwell]

I need to change the "field size" property in linked
tables. When I attenpt to modify in normal fashion, I get
the following message: "This property can't be modified in
linked tables."
I know there must be a way to get around that. Any advise
would be appreciated.
Al

 

[Kevin @ 3NF]

You have to make that change in the database where the table actually
resides.

 

[Van T. Dinh]

Yes. Open the Back-End database and modify the design of
the local Table (which is the linked Table at the Front-
End).

HTH
Van T. Dinh
MVP (Access)