Automatic Backup

[Raul Sousa]

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?

 

[jacksonmacd]

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.

 

[ciroteo]

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.

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

 

[Raul Sousa]

thank you very much

"ciroteo" escreveu:

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