Linked Table box size

  • Thread starter Thread starter Don Aultman
  • Start date Start date
D

Don Aultman

My links are veeery long. Can't see full link. How can I
set/change size of the Linked Table Manager?
 
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
 
My links are veeery long. Can't see full link. How can I
set/change size of the Linked Table Manager?
Click to expand...

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.
 
Back
Top