How do I edit linked tables?

B

B_Lyles

How can I edit liked tables? I no longer need a particular field and I wish
to just delete the field, but I keep getting a message saying I can't do
that. I tried to delete the relationship but this doesn't seem to be the
answer. Is there any way around it or do I have to create a whole new
database from scratch?
 
L

Lisap

I am having the same problem. There is a + sign in my table which expands
into the linked table. Is there a way to remove the link?
 
R

Rick Brandt

Lisap said:
I am having the same problem. There is a + sign in my table which
expands into the linked table. Is there a way to remove the link?
Click to expand...

The link is just a pointer to a table that exists *in another file*. You
have to make the change in that other file and then refresh the link.
 
L

Larry Daugherty

Sounds like two different issues.

The initial one seems to be that you are trying to get rid of a single
field in a linked table. The only way to do that is to go directly to
the linked table and delete the field. Be sure that no other use is
being made by anyone of that field. Also be aware that thing in your
current app such as queries must have the reference to that field
removed. If it's a case of your not needing any fields from that
linked table then just delete the linked table in your front end.

The other poster's issue sounds like a lookup field in the table
design. They are a terrifically bad idea. If you open your table in
design and find that it's a look,up field you can change the type in
the bottom area of the table design form. You will than have some
work to do to get the field to reflect the data you really want.

HTH
 
C

Cathy

I have a similar problem. I want to add fields to a table that is linked.
I've been able to do this in a COPY of the database on my c drive - by
unlinking the table, making my additions and then relinking - and now that I
want to try it on the ACTUAL database I get the following message: You can't
delete a relationship inherited from a linked database.

Any help is appreciated. Thanks
 
Top