remove the database link

S

subs

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

John W. Vinson

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.
 
S

subs

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.

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---
 
J

John W. Vinson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top