Getting location of linked tables database.

[Dan_T]

Hi,

I wish to return the path for the database where a linked table is located. I will continue looking myself but if anyone has the answer to hand I would appreciate it.

Many Thanks

Dan

 

[Uncle Gizmo]

There is an example at Rogers Access Library --- Excellent compendium of Access 2000 routines from Roger Carlson.


Extract:-
It also has a GetPath function which returns just the path of the directory where the database resides. I use this for finding the directory where the database lives so I can put my LinkRemote.mdb there. There is also a GetFile function which just returns the file name of the current database, but this is not used here.

 

[ghudson]

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