ACCESS FEED: [MS_AccessPros] Re: CopyFile method

Selasa, 28 Agustus 2012

[MS_AccessPros] Re: CopyFile method

Hi Adam,

You cannot copy an open file - it does not make sense.
Windows will prevent it.

It must be closed first. If you are just after the Db
structure then used the latest backup copy, otherwise
you will have to close the database in order to allow
the Copy.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@...> wrote:
>
> 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]
> >
>