ACCESS FEED: Re: [MS_AccessPros] CopyFile method

Senin, 27 Agustus 2012

Re: [MS_AccessPros] CopyFile method

I am assuming that the path is totally correct? This is the error that comes about when the "from" path and file name aren't correct.

Is the "goto" folder already in existence? If not, do you have the rights necessary to create it?

----- Original Message -----

Tried and failed. RT Error 76, Path not found.

--- In MS_Access_Professionals@yahoogroups.com , Jeff Jones <jpjones23@...> wrote:
>
> Have you tried a simpler syntax. For example:
>
> Sub TempCopy()
> FileCopy "G:\Folder1\MyFile.mdb", "C:\Folder2\MyFile.mdb"
> end sub
>
> This works fine on my PC.
>
> Jeff
>
> ----- Original Message -----
>
>
>
>
>
> Trying to copy and overwrite a set of files from a server directory to a local folder.
>
> My.Computer.FileSystem.CopyFile( "G:\ProdData\File1.mdb", "C:\CCW\File1.mdb", FileIO.UIOption.AllDialogs, FileIO.UICancelOption.DoNothing)
>
> I get a compile error, "Expected: ="
>
> What's missing?
>
> Adam
>
>
>
>
> --
>
>
> Jeffrey Park Jones
> Excel, Access, Word, Office Expert
> Excel and Access, LLCÂ®
> Christopher@...
> http://ExcelAndAccess.Com
> Toll Free 877-392-3539
> Direct Line 714-262-6893
>
> 919-671-9870
> 5109 Deer Lake Trail
> Wake Forest, NC 27587
> jpjones23@...
>
>
>
>
> [Non-text portions of this message have been removed]
>

--

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net

[Non-text portions of this message have been removed]