remove the database link

  • Thread starter Thread starter subs
  • Start date Start date
S

subs

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

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.
 
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.
Click to expand...

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---
 
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---
Click to expand...

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?
 
Back
Top