"jacksonmacd" <jackMACmacdo0n***@telus.net> ha scritto nel messaggio
news:2p5kj2l2sk5e24ggd28bbeqhopnsqvih3o@4ax.com...
> Depends what you mean by "periodically". If they consistently shut
> down the database each night so that it is inactive, then any backup
> software should be able to be scheduled for a middle-of-the-night
> backup.
>
> It's a different story if you want to make a backup when the database
> is active, because backup software will usually skip files that are
> currently open. To handle that situation, you could use the CopyFile
> Windows API in a VBA program to force the open backend MDB file to be
> copied into a new instance of the database. Then use the Windows Task
> Scheduler to periodically run the program.
>
>
> On Sat, 21 Oct 2006 03:35:02 -0700, Raul Sousa
> <RaulSo***@discussions.microsoft.com> wrote:
>
> >Hi all,
> >I would like to have a Schedule database backup. Is this possible?
> >I have a database being used by several people.
> >I told then to periodically make a backup. I am afraid they don't.
> >So I would like to automate this task. Is the any way of doing this?
>
>  --
> jackmacMACdon***@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security

>
> "jacksonmacd" <jackMACmacdo0n***@telus.net> ha scritto nel messaggio
> news:2p5kj2l2sk5e24ggd28bbeqhopnsqvih3o@4ax.com...
> > Depends what you mean by "periodically". If they consistently shut
> > down the database each night so that it is inactive, then any backup
> > software should be able to be scheduled for a middle-of-the-night
> > backup.
> >
> > It's a different story if you want to make a backup when the database
> > is active, because backup software will usually skip files that are
> > currently open. To handle that situation, you could use the CopyFile
> > Windows API in a VBA program to force the open backend MDB file to be
> > copied into a new instance of the database. Then use the Windows Task
> > Scheduler to periodically run the program.
> >
> >
> > On Sat, 21 Oct 2006 03:35:02 -0700, Raul Sousa
> > <RaulSo***@discussions.microsoft.com> wrote:
> >
> > >Hi all,
> > >I would like to have a Schedule database backup. Is this possible?
> > >I have a database being used by several people.
> > >I told then to periodically make a backup. I am afraid they don't.
> > >So I would like to automate this task. Is the any way of doing this?
> >
> >  --
> > jackmacMACdon***@telusTELUS.net
> > remove uppercase letters for true email
> > http://www.geocities.com/jacksonmacd/ for info on MS Access security
>
>
>
> i think you can also use an external tool. i found very useful cobian
> backup. it copies and keeps in zip format.
> it's free and very light.
> check it out on the internet
>
>
>