FileCopy Problem

[Douglas J. Steele]

Several things appear to be incorrect.

First, FileCopy doesn't accept parentheses.

Second, \\Backoffice\Data.mdb isn't a valid UNC (you're missing either the
server name or the share name)

Third, you need a complete file for the destination, not just a folder name.

 

[DS]

I'm using this to copy a file...but it keeps turning red.

FileCopy ('\\Backoffice\Data.mdb', '\\Backoffice\Trash')

I'm copying Data.mdb to the Trash folder.
Gotta be the syntax.
Thanks
DS

 

[Stuart McCall]

I'm using this to copy a file...but it keeps turning red.

FileCopy ('\\Backoffice\Data.mdb', '\\Backoffice\Trash')

I'm copying Data.mdb to the Trash folder.
Gotta be the syntax.
Thanks
DS

In addition to Doug's sound advice, you need to use double-quotes to
delineate strings. IOW the line should read (incorporating Doug's changes) :

FileCopy "\\ServerName\ShareName\Data.mdb", "\\ServerName\Trash\Data.mdb"

Substitute your actual server & share names of course.

 

[DS]

Several things appear to be incorrect.

First, FileCopy doesn't accept parentheses.

Second, \\Backoffice\Data.mdb isn't a valid UNC (you're missing either the
server name or the share name)

Third, you need a complete file for the destination, not just a folder name.

Thanks Doug,
The Server Name is Backoffice.
The file is on the root.
Is that OK?
Thanks
DS

 

[DS]

Thanks,DS

 

[Pieter Wijnen]

the root of which share?
ie \\BackOffice\Data\Data.mdb

Pieter

 

[DS]

the root of which share?
ie \\BackOffice\Data\Data.mdb

Pieter

It's on the c:\ drive of backoffice\\

DS

 

[Pieter Wijnen]

Then it should be \BackOffice\c$\Data.mdb

But that share is usually restricted

Pieter