Linked Tables, how to see the file name? (Access 2K, Win 2k)

Topic

New Reply

Dear All

I’ve just had to revisit a database I last worked on over a year ago, the thing that slowed me down was not being able to work out what the name of a linked Excel file was from the database window.

Is there any way of having Access show the name and location of linked files?

If I hadn’t documented the code refering to the link I’d have been in trouble. I’ve also had people change the target file by deleting and replacing the link, then wonder why related code doesn’t work any more (different database) so, is there a quick way to check the file name?

Thanks

Ian

Reply | Quote

Replies

The linked table manager will tell you.

Tools…Database Utilities…Liked Table Manager

I am not sure about Access 2000, but in 2003 you just have to hold the mouse over a table name in the db window and it shows the file name and path in the tool tip that appears.

Reply | Quote

There are several possibilities:

You can view and edit the link information in Tools | Database Utilities | Link Manager.

You can open a linked table in design view, ignore the warning that some properties can’t be modified, and look at the Description property of the table in the Properties window.

If you have a reference to the Microsoft DAO 3.6 Object Library in VB, you can type the following into the Immediate window

? CurrentDb.TableDefs(“NameOfLinkedTable”).Connect

Reply | Quote

Thanks for the replies, that tool tip ting would be brilliant if 2000 had it, pity we wont be upgrading to 2003 any time soon.

The properties window will do me, it even solved the long standing mystery of where the $ sign comes from in the error messages about tables not existing…

Thank You.

Ian

Reply | Quote