Linked Table Question

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

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 said:
i think you can only get it from the path of BE.
Click to expand...

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

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

Sorry, no suggestion here.
Click to expand...

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