>>>>>One of the solutions could be like this:
>>>>>oFSO = CREATEOBJECT("Scripting.FileSystemObject")
>>>>>
>>>>>lo= oFSO.GetFile(getfile())
>>>>>?lo.Drive.ShareName
>>>>
>>>>Yuri, first thank you for your help.
>>>>
>>>>Can you think why when I run your simple code (above), I get empty value of .ShareName? Could it be because I choose a file from my local drive?
>>>
>>>I do not get it: if you choose the file from the local drive, then what UNC you expect?
>>
>>You can always convert c:\sub\dire\cto\ry into \\127.0.0.1\c$\sub\dire\cto\ry (if the local IP is known, it can be used instead), but that's cheating, and I don't see any purpose to it.
>
>Very interesting. So, if we access a table using local IP and found it slow, we may get its actual path instead using a reverse code of Yuri's?
The difference would be, I assume, minimal. You'd get some speed by circumventing the network layer, but that's just some code which still runs only locally.
I think the above way of accessing your local tables via an UNC is actually a good way to test how your app works with UNCs without having to really employ two machines for that. But that's pretty much all the use it can have... unless you count the face anyone who sees what you're doing would make :)