Linked Table box size

[Don Aultman]

My links are veeery long. Can't see full link. How can I
set/change size of the Linked Table Manager?

 

[Douglas J. Steele]

You can't. It's been a sore point with many of us for years.

If you want to see what your links are, you can write a routine to dump the
information. Assuming you have a reference set to DAO, the following will
print your links to the Debug window:

Sub PrintLinks()

Dim dbCurr As Database
Dim tdfCurr As TableDef

Set dbCurr = CurrentDb()
For Each tdfCurr In dbCurr.TableDefs
If Len(tdfCurr.Connect) > 0 Then
Debug.Print tdfCurr.Name & " is linked to " & tdfCurr.Connect
End If
Next tdfCurr

Set tdfCurr = Nothing
Set dbCurr = Nothing

End Sub

 

[John Vinson]

My links are veeery long. Can't see full link. How can I
set/change size of the Linked Table Manager?

Alas, I know of no way to do so. It's a design flaw on Microsoft's
part.

Note that empirically, very long file names are associated with poor
performance; moving the backend database to a top-level directory can
cause dramatic improvements.