Saving reports to folders

[Guest]

OS server 2003, Office 200

I wrote a program in access to save reports in specific folders. This works fine in a single computer but when I load the program to a server it fails to save. Here is the exact line (Pitserver is the server

DoCmd.OutputTo acOutputReport, ,"snapshotFormat", "D:\Old Charts\testfolder\filename" & ".snp", False, "" ,0

This works fine but of course can only be used in the local computer where D:\ is the drive where old charts are and will not work over a network where the drive is no longer loca

DoCmd.OutputTo acOutputReport, ,"snapshotFormat", "\\pitserver\Old Charts\testfolder\filename" & ".snp", False' "",
This does not wor

I made a hyperlink within the program using "\\pitserver\Old Charts\testfolder" and I get to the appropriate folder so I know that the path works I just think may be the syntax is wrong

Your help will be greately appreciated

 

[Elwin]

Change the ' after False to a comma. If that was just a
transposition typo then check that all users have write
access to the directory. good luck.

-----Original Message-----
OS server 2003, Office 2003

I wrote a program in access to save reports in specific

folders. This works fine in a single computer but when I
load the program to a server it fails to save. Here is the
exact line (Pitserver is the server)

DoCmd.OutputTo acOutputReport, ,"snapshotFormat", "D:\Old

Charts\testfolder\filename" & ".snp", False, "" ,0

This works fine but of course can only be used in the

local computer where D:\ is the drive where old charts are
and will not work over a network where the drive is no
longer local

DoCmd.OutputTo

acOutputReport, ,"snapshotFormat", "\\pitserver\Old
Charts\testfolder\filename" & ".snp", False' "", 0

This does not work

I made a hyperlink within the program

using "\\pitserver\Old Charts\testfolder" and I get to the
appropriate folder so I know that the path works I just
think may be the syntax is wrong.