If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
remove the database link
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] |
#3
|
|||
|
|||
remove the database link
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--- |
#4
|
|||
|
|||
remove the database link
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] |
Thread Tools | |
Display Modes | |
|
|