Create map to drive while in access?

[Hafeez Esmail]

I have FEs and a BE DB all located at the following
path "\\server1\fldr1\fldr2\filename". I split my DB into
FEs/BE because there are separate jobs the users want to
perform with the same data. I then gave them each a
shortcut to the FEs, cause it requires much less space.

I have a form that creates and exports a query (with the
parameters of their choice) and saves the file to their
desktop. After going through the Access MVP site, I found
a piece of code (developed by Dev Ashish) that retrieves
the user's WINNT login id. So the path looks like this...

"C:\winnt\profiles\" & strUsrName & _
"\desktop\MyQuery.xls"

The problem I'm having is with the DoCmd.OutputTo
subroutine.

On my computer, \\server1 is mapped to the D drive. On
similar computers, there is not problem, however on
computers \\server1 is not mapped to the D drive, I get an
error and am not able to output the object.

Since I don't have admin privilages, I'd have to go to
each individual and create a common area for them. They
themseves wouldn't be able to follow simple directions
(like creating a map to a network drive)

One way, I think, that would solve this probelm was if
there was a way to create (and then delete) a map to the
DB within access.

Thanks for you help Gary
Hafeez Esmail

Any help is muchly appreciated
Hafeez Esmail

 

[Douglas J. Steele]

Why not use a UNC (\\server1\share\folder\file.mdb) instead of
D:\folder\file.mdb?

 

[Hafeez Esmail]

I've referenced the file as a UNC but the error message I
get (when another computer runs the file) is
D:\folder\file.mdb

 

[Hafeez Esmail]

I finally found out what you were talking about.
I deleted all of the linked tables and typed in the UNC in
the "File name:" field.

Thanks for your help!
Hafeez Esmail