Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Linked Tables, how to see the file name? (Acce

    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.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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

  4. #4
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •