how to backup through VBA code in Access 2007?

19 Oct 2008 12:10 PM

PKJoshi

I want an expert's advice to take data backup through VBA code in one of ny
forms. Please help.

19 Oct 2008 5:29 PM

Tom van Stiphout

On Sun, 19 Oct 2008 05:10:00 -0700, PKJoshi
<PKJo***@discussions.microsoft.com> wrote:

Typically backups run at night when there are no users in the
database. NtBackup.exe is a free program already on your computer. Why
would this not work in your case?

Note: making backups (copies of the back-end db) while users are in
the database works 99% of the time. Is that good enough for you?

-Tom.
Microsoft Access MVP

Show quoteHide quote

>I want an expert's advice to take data backup through VBA code in one of ny
>forms. Please help.

24 Oct 2008 2:21 PM

PKJoshi

Thank You Tom for the valuable guidance about using ntbackup.exe. But I
wanted to save a copy of the db whenever the user chooses to exit the
application. Is there any way to save the db when it is open. I searched the
web but have been unlucky till this time. Thanks again!

Show quoteHide quote

"Tom van Stiphout" wrote:

> On Sun, 19 Oct 2008 05:10:00 -0700, PKJoshi
> <PKJo***@discussions.microsoft.com> wrote:
>
> Typically backups run at night when there are no users in the
> database. NtBackup.exe is a free program already on your computer. Why
> would this not work in your case?
>
> Note: making backups (copies of the back-end db) while users are in
> the database works 99% of the time. Is that good enough for you?
>
> -Tom.
> Microsoft Access MVP
>
>
> >I want an expert's advice to take data backup through VBA code in one of ny
> >forms. Please help.
>