How can I get a printed list of Linked tables

  • Thread starter Thread starter Phil
  • Start date Start date
P

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.
 
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
 
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
 
This is extremely helpful.

Thank you so much!!
--
EugeneH


John Spencer said:
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.
Click to expand...
Click to expand...
 
John Spencer said:
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.
Click to expand...
Click to expand...
 
Back
Top