ACCESS FEED: [MS_AccessPros] Re: CopyFile method

Senin, 27 Agustus 2012

[MS_AccessPros] Re: CopyFile method

Got the FileCopy to work (typo in the file path). However, it doesn't work with an open file. The file that's open is a back end .mdb file that others are using. Is there a way around this other than having them manually copy it in Windows Explorer?

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Adam
>
> try this:
>
> '~~~~~~~~~~~
> ï¿½ï¿½ Name "G:\ProdData\File1.mdb" AS "C:\Folder2\MyFile.mdb"
> '~~~~~~~~~~~
>
> Warm Regards,
> Crystal
>
> Learn Access on YouTube
> http://www.YouTube.com/LearnAccessByCrystal
>
> ï¿½*
> ï¿½ï¿½ (: have an awesome day :)
> ï¿½*
>
>
> ________________________________
> From: AdamF <runuphillracing@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, August 27, 2012 2:17 PM
> Subject: Re: [MS_AccessPros] CopyFile method
>
> 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]
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>