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

  • Thread starter Thread starter Author
  • Start date Start date
A

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
 
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
 
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'
Click to expand...
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.
Click to expand...
Imho that is not true.
How do I get the file path on the *server*? (i.e. not starting with S:\ )
Click to expand...
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?
Click to expand...
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 <--
 
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.
 
Back
Top