How To Show Linked Tables In Microsoft Access

IT Support Forum Forums Windows Windows 10 Applications How To Show Linked Tables In Microsoft Access

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 6 months, 3 weeks ago.

  • Author
    Posts
  • #2347

    Webmaster
    Keymaster

    Use the following SQL query to show a list of linked tables in Microsoft Access:

    SELECT MSysObjects.Name, MSysObjects.ForeignName, MSysObjects.Database
    FROM MSysObjects
    WHERE ((Not (MSysObjects.ForeignName) Is Null));

    This query shows the linked tables in Microsoft Access, along with the location of the dated linked to.

You must be logged in to reply to this topic.