How to Delink a table

P

pokdbz

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
 
N

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
 
A

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
 
P

pokdbz

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

Nikos Yannacopoulos said:
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
Click to expand...
 
P

pokdbz

Got it.
Thanks

Arvin Meyer said:
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
Click to expand...
 
Top