How To Show Linked Tables In Microsoft Access

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

Viewing 0 reply threads
  • 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.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.