Here's an API based method to make a backup of the current database.
Please note that this function does not work on Exclusively opened database.
http://access.mvps.org/access/api/api0026.htm
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Clive <zctek@aol.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, August 28, 2012 3:44 AM
Subject: [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
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar