How to Delink a table

[Guest]

I have a table that I have to add a field too. When I go to save the table
it says that it can't because it is a linked table. How do I remove the link
to add my field.
Thanks

 

[Nikos Yannacopoulos]

Hmm... you don't "delink" a table to do that! This means the table
belongs to another database file, and you have to open that file to make
the change into.

HTH,
Nikos

 

[Arvin Meyer]

Go to the back end database. If it's an mdb, all you need to do is to add
the field and it will show up. ADPs require adding the field in the back-end
then unlinking from the front-end (Just delete the file in the front-end ...
all it is is a connection) then re-linking to the back-end.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

So what do I have to do to add a field?

Hmm... you don't "delink" a table to do that! This means the table
belongs to another database file, and you have to open that file to make
the change into.

HTH,
Nikos

 

[Guest]

Got it.
Thanks

Go to the back end database. If it's an mdb, all you need to do is to add
the field and it will show up. ADPs require adding the field in the back-end
then unlinking from the front-end (Just delete the file in the front-end ...
all it is is a connection) then re-linking to the back-end.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Nikos Yannacopoulos]

I suppose Arvin's reply more than covers it!

So what do I have to do to add a field?

: