I came across an old database at work and some of the tables are linked (either to a table in a different database or to an Excel spreadsheet). My problem is I can't locate the files where the actual information is. How can I get that info?

Click on the linked table. Click "Design" in the database window. You'll get a message saying "Table 'your table' is a linked table with some properties that can't be modified. Do you want to open it anyway?" Click the "Yes" button. You'll get the design screen of the table. Click "View | Properties". A pop up box will pop up. Your answer is in the top line under description. You can stretch the pop up if it's a long path.

hth

John

Edited by: JohnnyB on 03.17.04.

I guess that's the same as right clicking on the table name and choosing properties. There's a box for descritpion but it's empty. On top of it it says the name of the table and that it's linked. No more. Maybe there's some restrictions on the database about giving information. Is it possible? What should I do then?

You can use Linked Table Manager to help.
Go to Tools>Database Utilities>Linked Table Manager
Now you can check for each linked tables for its source container.

If the Linked Table Manger is not installed, you can type the line below in Immediate Window and find it out. Press Ctrl + G to open the Immediate window and replace ALinkedTableNameHere with a linked table name you want to find its source.

? Mid(CurrentDb.TableDefs("ALinkedTableNameHere").Connect, 11)

It's not the same. I did the same thing you did, right clicking on the table name and got the blank box just like you. Try the design icon. If that doesn't work, try TimK's idea.

I tried what Tim says and got my info. I tried the little code too. Thanks!!!