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

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.

i did that and it deleted the table

i did that and it deleted the table

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.

ok.....i see it now. Thank you so much for the quick response

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.

now, i'm going to link them to the SQL Server