Obtaining Server File Name

[dwylie]

Ok, I have a database that will be passed around corporate and nationwide
which asks users to select pictures, which will return its respected file
address into a table. Understandably, most users have these addresses
mapped, thus a common address would be H://filelocation/filepicker.....
Problem is when you store this address into a table, other users can't
identify the whole location, and the respected file cannot open. I need the
whole address..... //corporateserver/basketball/filelocation/filepicker

I have the correct filedialog code for basic file address return.

Is there a way or code to return the full file address (i.e:
//corporateserver/bask....)???

With gratitude.

 

[datAdrenaline]

Check out this ..

http://support.microsoft.com/?kbid=210050

I have NOT used it, I just found when searching for a solution to your issue
at my normal stomping grounds (www.utteraccess.com)

 

[Douglas J. Steele]

The filedialog (which can be troublesome, and should be replaced by the code
in http://www.mvps.org/access/api/api0001.htm at "The Access Web") will
return a UNC if you navigate to the file through the Network Neighborhood
(or whatever it's called in your version of Windows), rather than navigating
to the file using a mapped drive.