Drive path vs. Network Path S:\Shared\Folder vs. \\NETWORK\USER\FO

[Author]

Searched my bookmarks and couldn't find where I had read this conversation
before.
I am working with a linked database. (My copy of) the Front End contains a
Module that runs a query to refresh data in a table on the Back End. My
problem is I need the path of the Back End Database; currently when I run the
code I get Run-Time 3024, 'Could not find file
\\COMPANYNETWORK\VOLA\USERS\MYNAME\BEDatabase.mdb'
I remember hearing (read: lurking) a discussion about how using the Network
path instead of the file path was more stable, less error prone, etc.
How do I get the file path on the *server*? (i.e. not starting with S:\ )
Why do I need to use the server path instead of the drive path?
Thankya
-Pete

 

[Michel Walsh]

With the network path, you don't have to make any special installation, such
as being sure a drive S exists (and is not use for any other purpose). So,
it is easier to install and less error prone. That is, at least, one reason.


Vanderghast, Access MVP

 

[Stefan Hoffmann]

hi Pete,

problem is I need the path of the Back End Database; currently when I run the
code I get Run-Time 3024, 'Could not find file
\\COMPANYNETWORK\VOLA\USERS\MYNAME\BEDatabase.mdb'

An UNC path looks like that:

\\server\share\[path\][file]

"server" is the name of the hosting server, it is not the name of your
network or your domain.
"share" is the name of the published folder or device.

I remember hearing (read: lurking) a discussion about how using the Network
path instead of the file path was more stable, less error prone, etc.

Imho that is not true.

How do I get the file path on the *server*? (i.e. not starting with S:\ )

You have to know that as you have to know that it is otherwise the
mapped drive S:.

Why do I need to use the server path instead of the drive path?

Even in a managed environment it is not always possible on some machines
to use that drive letter. A solution using a mapped drive needs to
relink its backend tables, while a solution using UNC paths doesn't.


mfG
--> stefan <--

 

[Dale Fye]

Generally, I go to windows explorer (not IE), click on the My Network Places,
and locate the path I'm looking for that way.

Alternately, you could ask one of your IT guys what the NIC path is for a
particular shared folder.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Klatuu]

Here is a link to an api that will convert a drive map path to a unc path
plus a few other nice goodies:

http://www.mvps.org/access/api/api0003.htm

To convert to a unc:
?fgetuncpath("o:")
\\rpidalrpo001\RealPro