Network path

[valeryk2000]

Access 2003/2007
Application.CurrentProject.Path - returns mapped drive path.
Question: how can we get full network path, smthng like \\server\sharedrive\etc ?
Thanks

 

[mdlueck]

Sounds like you want the mapped drive letter turned back into a UNC.

I did a quick search for VBA UNC and came up with this:

VBA to Return the UNC(Universal Naming Convention) Path of a Mapped Network Drive
http://www.excelfox.com/forum/f13/v...ing-convention-path-mapped-network-drive-134/

That example did not include proper housekeeping. Should drop the objects by setting them to nothing... something like...

Set objNtWork = Nothing
Set objDrives = Nothing

once they are done being used.

 

[valeryk2000]

Thanks. I forgot to which library "WScript... " belongs?

 

[mdlueck]

I forgot to which library "WScript... " belongs?

Looks like it is in...
"Windows Script Host Object Model" (C:\WINDOWS\system32\wshom.ocx).

Per:
http://forums.aspfree.com/windows-scripting-64/using-wscript-access-283584.html

 

[valeryk2000]

You won't believe it - but this function works ok without special referencing a library - windows library is referenced by default?
Thank you Mike!