Seeing complete source location of linked tables

[JASelep]

When I use the Linked Table Manager (Office2003)
I'm unable to see the extreme right of the list which holds the most
important part of the list
is there a way to print the linked table names and the FULL source location
of the linked tables?

How can I see the Full location of the source of the linked table.
I'm not able to enlarge the window to see the right side and
no scroll bars are evident to scroll to see the most detailed part of the
source location

 

[Douglas J. Steele]

The following SQL will give you what you're looking for:

SELECT [Name], Database, ForeignName
FROM MSysObjects
WHERE [Type]=6
ORDER BY [Name]

 

[Larry Linson]

When I use the Linked Table Manager (Office2003)
I'm unable to see the extreme right of the list which holds the most
important part of the list
is there a way to print the linked table names and the FULL source
location
of the linked tables?

How can I see the Full location of the source of the linked table.
I'm not able to enlarge the window to see the right side and
no scroll bars are evident to scroll to see the most detailed part of the
source location

It _is_ a pain, isn't it, when the developers do not realize how long, and
deep, qualified path-and-file names can be, and provide a minimal popup
dialog?

Three workarounds, both of which fall short of ideal, which would be
"provide, at least, scrolling capability in all Access popup dialogs, so we
can see long path-and-file names":

1. Rename/rearrange your folder hierarchy so that the full name shows in
the space provided.
2. In the Linked Table Manager, check the box "Always prompt for new
location" which will open a Windows Common Dialog window which will let you
see the longer path-and-file name.
3. You could write your own code as a replacement... there's sample code
in the Developer Solutions database for Access 2000 for relinking tables at
startup. I'm sure that sample database is still, somewhere, on the Microsoft
site but the site has been restructured ("to provide a richer user
experience," I am certain) and that sample moved so many times, I just
recommend going to http://support.microsoft.com and searching the Knowledge
Base for Access 2000 with "Developer Solutions".

Larry Linson
Microsoft Office Access MVP

 

[Peter Hibbs]

Are you sure? On my copy of A2003 that list box has a horizontal
scroll bar (but it is NOT present on A2000). Also on A2003 (but not
A2000) you can hover the mouse over a linked table in the database
window to show the full link pathname.

Peter Hibbs.