how to backup through VBA code in Access 2007?

[PKJoshi]

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

 

[Tom van Stiphout]

On Sun, 19 Oct 2008 05:10:00 -0700, PKJoshi

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

 

[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!