Syntax to copy a file

[wayne zabel]

I use ---

DoCmd.OutputTo acTable, "Payments", "MicrosoftExcel(*.xls)",
"c:/payments.xls", False, ""

-----To backup a table to my c drive. What would the syntax be to backup the
file to the c drive on another computer located on my network. The name of
the computer is "Barbara-PC"

 

[Guest]

I'm not networked right now to test but I believe it would simply be

DoCmd.OutputTo acTable, "Payments", "MicrosoftExcel(*.xls)",
"\\Barbara-PC\c$\payments.xls", False, ""

The basic synthax should be
\\server1\share\folder\filename.extension

You need to know what name has been given to the share on the other computer
you are trying to work with.