Map a Drive in Access

[MAB]

I need to output a report to the shared folder of another computer from
Access XP. I have no problem with creating the report and sending it out.
But I need, just temporarily, to map a drive letter to the folder I want to
send it to. I don't want to have this drive mapped all the time. It needs to
be mapped, the report sent, and then unmapped when done. Is there a way to
do this in Access?
Thanks!

 

[Nikos Yannacopoulos]

Mike,

There's a better way to do this... don't map (generally not recommended),
use a UCN address instead, i.e. send your report as something like:
\\ComputerName\FolderName1\FolderName2...\FileName.ext
This method is preferable in that it is not mapping-dependent, so as long as
the target computer (or, generally, server) name does not change, it can
work on any PC on a network regardless of mapping.

HTH,
Nikos