How to add a field in linked tables?

J

JR619

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!!
 
D

Dennis

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

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
 
J

JR619

Thank you very much for all of the help!!

M Skabialka said:
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
Click to expand...
 
Top