Distribution of front end to clients

[Michelle]

I have developed an Access 2000 application for
distribution to several groups. I created it on a shared
network drive to which I am mapped using the drive
letter Q. All of the client users have permissions on the
proper folder on the network drive \\amssc-01\CmdMedia$

Is there a setting or command which allows me to specify
the UNC Path (i.e. \\amssc-01\CmdMedia$\PBM\MDC.mdb) is
the absolute path to the source? If not, is the only
option for all client users to map their drive letter Q to
the network fileshare \\amssc-01\CmdMedia$ ?

I am trying to find a solution for the error that occurs
when a user clicks on a button in the application
that opens a form and they get the error:

'Q:\PBM\Metrics\MDC_be.mdb' is not a valid path. Make
sure that the path name is spelled correctly and that
you are connected to the server on which the file resides.

Any help would be greatly appreciated,
Michelle

 

[Bruce M. Thompson]

Is there a setting or command which allows me to specify

the UNC Path (i.e. \\amssc-01\CmdMedia$\PBM\MDC.mdb) is
the absolute path to the source?

If you remove the mapping and then, in Linked Table Manager, navigate through
the network to the MDB file, it should stick when selected. I have often found
that if you have a drive mapped to the UNC path, after selecting the MDB, the
path gets converted to the mapped drive format. You can also try typing the UNC
directly into the file dialog.

 

[Jen]

Hi,

I've found that if you just type in the \\amssc-01
\CmdMedia$\PBM\MDC.mdb in the name box in the link dialog
box that you'll have the virtual path instead of
the 'hard' path. This way if a user doesn't have to be
mapped to the drive in order to get to the data.

Regards,
Jen

 

[Michelle]

Thank you very much, that was exactly the problem.

 

[Michelle]

Thank you very much for the very helpful advice.

-----Original Message-----

If you remove the mapping and then, in Linked Table Manager, navigate through
the network to the MDB file, it should stick when selected. I have often found
that if you have a drive mapped to the UNC path, after selecting the MDB, the
path gets converted to the mapped drive format. You can also try typing the UNC
directly into the file dialog.

--
Bruce M. Thompson
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
within the newsgroups so that all might benefit.<<


.