I want to delete a link to a linked table without deleting the actual table. The tables where linked when the application was designed by another user. So the tables links are pointing to C:\documents and settings\user name\desktop\database name. I want to delete the links to all the tables so It can be upsized to SQL Server. Any Suggestions????
Deleting link in linked tables
- Thread starter mrsgwen
- Start date
SOS
Registered Lunatic
- Local time
- Today, 07:08
- Joined
- Aug 27, 2008
- Messages
- 3,512
Just go to the database window or Navigation pane (if on 2007) and right click on the table and select DELETE. It will delete the LINK but the table will still be intact back where it is located. If you do it for any NOT LINKED tables then it will delete the table, but linked tables it only deletes the link.
SOS
Registered Lunatic
- Local time
- Today, 07:08
- Joined
- Aug 27, 2008
- Messages
- 3,512
No, it just LOOKS like it did. When you delete a link it removes that table from the list. Go to the actual place where the table was from and it will still be there.
SOS
Registered Lunatic
- Local time
- Today, 07:08
- Joined
- Aug 27, 2008
- Messages
- 3,512
If you want to just change where it is linked to, then use the LINKED TABLE MANAGER which then you can click on the box that says ALWAYS PROMPT FOR NEW LOCATION and check the boxes of the ones you want to relink and then click OK and it will let you select the database in the new location to link to.
