Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hidden?? Linked Table (Access 2000)

    I have a table that is linked to another database. When I look in the source DB, I can't find the table (I have show hidden objects ON).

    Originally I presumed the link to be a mistake, but I can open the table up when double-clicking on the link.

    I must be missing something prety simple here - surely??

    OK - I THINK the mystery is solved. The name of the table has been changed in the destination DB. Is there a way to prove that? A nice bit of code maybe?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden?? Linked Table (Access 2000)

    In tools, options check the system Objects checkbox.
    Open the table MSysObjects.
    In the column Name look for the linked table.
    You will find the Name of the table in the original MDB in the column ForeignName and the name and the path of the original MDB in the column Database.
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden?? Linked Table (Access 2000)

    Thanks Francois.

    Someone did change the name - don't know why though!!

    John

Posting Permissions

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