ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Long file paths in MS Access Linked Table Manager (https://www.excelbanter.com/excel-programming/323948-long-file-paths-ms-access-linked-table-manager.html)

Todd huttenstine

Long file paths in MS Access Linked Table Manager
 
Hey

In Microsoft Access, I am trying to see some file paths in
Linked Table Manager, however, the file names are longer
than Linked Table Manager dialog and I cant resize this.
From reading some Google newsgroup posts, I understand it
is not possible to resize it, you have to do it
programmatically. Can anyone give me a code that will do
this or is there a regestry setting or anything I can
change?


Thanks in advance.

Todd Huttenstine

Todd huttenstine

Long file paths in MS Access Linked Table Manager
 
I found this code on Google Newsgroups thats works... See
below:



SELECT [MSysObjects].[Connect], [MSysObjects].[Database],
[MSysObjects].[ForeignName]
FROM MSysObjects
WHERE ((([MSysObjects].[Database]) Is Not Null));


-----Original Message-----
Hey

In Microsoft Access, I am trying to see some file paths

in
Linked Table Manager, however, the file names are longer
than Linked Table Manager dialog and I cant resize this.
From reading some Google newsgroup posts, I understand it
is not possible to resize it, you have to do it
programmatically. Can anyone give me a code that will do
this or is there a regestry setting or anything I can
change?


Thanks in advance.

Todd Huttenstine
.



All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com