Linked Table Question

[Joe Williams]

I have a classic front end/back end database. All linked tables reside in
one beck end MDB on a server.

Is there a way to retrieve the MACHINE name that the linked table database
resides on through code? I am looking for the machine name only, not the
path. Thanks

Joe

 

[Alex Dybenko]

i think you can only get it from the path of BE.

 

[Bas Cost Budde]

i think you can only get it from the path of BE.

Not if it is mapped. My BE is at m:\database\v3, no machine name.

Sorry, no suggestion here.

 

[John Nurick]

Not if it is mapped. My BE is at m:\database\v3, no machine name.

Sorry, no suggestion here.

Starting with the mapped drive letter you can use the Windows API to get
the corresponding machine and share names. I think it's the
NetShareGetInfo() function; there's a VB class wrapper for it in the API
Guide (www.allapi.net).

 

[Alex Dybenko]

Thanks John, fully agree