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


"Author" <(E-Mail Removed)> wrote in message
news:1AC0DBD6-9B53-4E2D-AA19-(E-Mail Removed)...
> 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

hi Pete,

Author wrote:
> 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 <--

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.



"Author" wrote:

> 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

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
--
Dave Hargis, Microsoft Access MVP


"Author" wrote:

> 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