How can I get a printed list of Linked tables

[Phil]

I want to list the tables that I have linked from other Acces databses
including the full path.
I am not a programmeer but very adept at using queries etc.

 

[Tom van Stiphout]

On Fri, 10 Oct 2008 07:00:02 -0700, Phil

Show the hidden and system objects. Then create a query on
MSysObjects.

-Tom.
Microsoft Access MVP

 

[John Spencer]

You can try the following query

SELECT MSysObjects.Name, fgetTablePath([Name]) AS TheLink
FROM MSysObjects
WHERE (((MSysObjects.Type)=6));


Which will need this function in a vba module

Public Function fGetTablePath(strTableName) As String

fGetTablePath = CurrentDb().TableDefs(strTableName).Connect

End Function


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Eugene7899]

This is extremely helpful.

Thank you so much!!
--
EugeneH

You can try the following query

SELECT MSysObjects.Name, fgetTablePath([Name]) AS TheLink
FROM MSysObjects
WHERE (((MSysObjects.Type)=6));


Which will need this function in a vba module

Public Function fGetTablePath(strTableName) As String

fGetTablePath = CurrentDb().TableDefs(strTableName).Connect

End Function


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I want to list the tables that I have linked from other Acces databses
including the full path.
I am not a programmeer but very adept at using queries etc.

 

[cesar]

You can try the following query

SELECT MSysObjects.Name, fgetTablePath([Name]) AS TheLink
FROM MSysObjects
WHERE (((MSysObjects.Type)=6));


Which will need this function in a vba module

Public Function fGetTablePath(strTableName) As String

fGetTablePath = CurrentDb().TableDefs(strTableName).Connect

End Function


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I want to list the tables that I have linked from other Acces databses
including the full path.
I am not a programmeer but very adept at using queries etc.