Linked Table Manager file path view truncation problem

[Jean-Guy]

How do you get to see the entire file path in Access Linked Table Manager of linked tables that are located in a folder with a long path? The problem is that you can only view the first 64 or so characters of the table’s path. This is a real problem when these linked tables need to be updated and you don't know where it’s stored.

Jean-Guy

 

[ghudson]

Not possible in that dialog box.

You can run this query to see it all...

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type) In (4,6)))
ORDER BY MSysObjects.Name;

LINKED TABLES [4 = ODBC, 6 = Access]:

 

[Jean-Guy]

Thanks -- good work around

Thanks a bundle ... this is a good work around till Microsoft eventually fixes this problem.

I've modified your query slightly, as shown below, to also display the table's database with its associated path.

------

SELECT MSysObjects.Name, MSysObjects.Database
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type) In (4,6)))
ORDER BY MSysObjects.Name;

-------

Regards,

Jean-Guy

 

[ghudson]

Oops. I gave you the wrong one for that was what I meant to post to display the \path\file location.