filecopy - error 76 Path not found

[Diane]

I am trying to do a filecopy from within Access of a
spreadsheet and need to use the UNC instead of the mapped
drive since not everyone has the same mappings since this
application is being used by many companies. However I am
getting error number 76 path not found on it. Any
suggestions as to how I can make this happen?
Thanks,
Diane

 

[Elwin]

It works ok for me. Check your syntax? Try mapping to
the location to check the validity of your UNC path.

FileCopy "C:\mySheet.xls", "\\sys3\data\myCopy.xls"

 

[Douglas J. Steele]

I believe you'll get an Error 76 if you don't have access to either the
source or the target.