OutputTo Using MapPath?

[susor]

I'm doing something new here -- well, new for me anyway. And I'm far from a network guru so I need to know if this can even be done.

I'm trying to drop a .doc file (report) into our fax software (LightningFax). In testing I dropped the .doc file into the same folder as the Access database on my own machine, and it worked fine:

stReportName = "C:\FAX\Fax" & rs3.Fields("NextReportNo").Value & ".doc"
DoCmd.OutputTo acOutputReport, "Fax Report", acFormatRTF, stReportName, False

But then I changed it to go to the folder on the server where LightningFax needs to find it:

stReportName = "\\prxweb\faxreport\Fax" & rs3.Fields("NextReportNo").Value & ".doc"
DoCmd.OutputTo acOutputReport, "Fax Report", acFormatRTF, stReportName, False

It still dropped it into the same folder as before on my own machine.

Can this even be done? Should it work? If it should work, and its not, is it a network configuration problem?

Thanks in advance for any help anybody can provide.

Scott

 

[BukHix]

susor does that path work when you navigate to it with Explorer?

 

[susor]

Problem Solved!

It was the short circuit between my brain and my keyboard. I had changed the place to LOOK FOR the file, but I didn't actually change the place where the file was going -- two different things. Somebody please shoot me.

Scott