How to add a field in linked tables?

[Guest]

I am trying to add a field to a table in a database created by another
indivdual. When I try to view in design view a message pops up stating
"Table is a linked table with some properties that cannot be modified." I
have tried to go in the table and add, however the database will not allow
the changes to be made. I am fairly new at using the system and am unsure
what my next step should be.

Thanks for any help!!

 

[Guest]

To add a field to a linked table, you need to add it to the table in the
database that is being linked to, and not in the table that is doing the
linking.

 

[M Skabialka]

If you have a linked table there are two databases. Your tables are in one
(the Back End) and the forms, reports, queries, etc are in the other (the
Front End).

Open the Back End while no-one is in the database and make your changes
there. Your Front End will recognize the changes when you open it back up.

HTH,
Mich

 

[Guest]

Thank you very much for all of the help!!

If you have a linked table there are two databases. Your tables are in one
(the Back End) and the forms, reports, queries, etc are in the other (the
Front End).

Open the Back End while no-one is in the database and make your changes
there. Your Front End will recognize the changes when you open it back up.

HTH,
Mich