remove the database link

i have a table which is linked to some other table or database. how
would i remove the link to this table?

On Thu, 18 Feb 2010 19:11:44 -0800 (PST), subs wrote:

i have a table which is linked to some other table or database. how
would i remove the link to this table?

Simply select the "table" (the link) in the Tables window in the database
design window, and press the Delete key. Accept the offer to delete the link.

You can also do it programmatically if that's what you're asking.
--

John W. Vinson [MVP]

On Feb 18, 10:25*pm, John W. Vinson
wrote:
On Thu, 18 Feb 2010 19:11:44 -0800 (PST), subs wrote:
i have a table which is linked to some other table or database. how
would i remove the link to this table?

Simply select the "table" (the link) in the Tables window in the database
design window, and press the Delete key. Accept the offer to delete the link.

You can also do it programmatically if that's what you're asking.
--

* * * * * * *John W. Vinson [MVP]

i have a linked table. i want only the table and not the link. the
table is too big to copy. and if i export the table to another
database, it comes up with the link-- how would i get the table
only---

On Thu, 18 Feb 2010 19:46:34 -0800 (PST), subs wrote:

On Feb 18, 10:25*pm, John W. Vinson
wrote:
On Thu, 18 Feb 2010 19:11:44 -0800 (PST), subs wrote:
i have a table which is linked to some other table or database. how
would i remove the link to this table?

Simply select the "table" (the link) in the Tables window in the database
design window, and press the Delete key. Accept the offer to delete the link.

You can also do it programmatically if that's what you're asking.
--

* * * * * * *John W. Vinson [MVP]

i have a linked table. i want only the table and not the link. the
table is too big to copy. and if i export the table to another
database, it comes up with the link-- how would i get the table
only---

You've lost me completely.

If you have a link in your table, and you import or export it, you're
importing or exporting *the link* - a pointer to the table; not the table
itself.

If you want to import the table you need to import it from the backend where
it actually resides.

Where does this table (the actual data table) reside?
What are these two databases: the one you're importing from and the one you're
exporting to? What do you want to end up with: two copies of the (too big)
table, or two links to it, or what?
--

John W. Vinson [MVP]