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

On Sun, 19 Oct 2008 05:10:00 -0700, PKJoshi
<(E-Mail Removed)> 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.

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!

"Tom van Stiphout" wrote:

> On Sun, 19 Oct 2008 05:10:00 -0700, PKJoshi
> <(E-Mail Removed)> 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.
>