autobackup in different folder

[andyukcy]

Hi guys,
How can i backup (copy) a database called for example a.mdb located on the desktop, to c:/backup/a.mdb every wednesday?

Thank you for your help
andy

 

[andyukcy]

It would also be nice for the database to be compacted as well at the same time , and the twoi copies that would stay on my computer (one on desktop and one in: c:/backup/a.mdb to be compacted

 

[natatbh]

Hi andyukcy,

Create two scheduled tasks.

One would compact your DataBase. ex.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" C:\MyFolder\MyDBase.mdb/compact

The second would call a macro which in turn would call
a function. The function would look like this,
FileCopy "C:\Folder1\myDB.mdb","C:\Desktop\backUp.mdb"

The task would look like this,

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" H:\MyFolder\MyDBase.mdb/x"MyMacro"

Schdule them to run weekly on wed.

natatbh