Can I create a backup task through a Macro

[gfbush]

Hi all, everything is cool now and my database now runs great, so thanks for all of your help.

My final thing is i want to back up the database and know that I can use the 'Backup' task from the Main menu, but the database is being used by office staff so I'd like to make it automatic. One task that happens is that important data is transferred between one table and another and so before this happens I'd like to back it up and wondered if I can include this in a Macro.

TIA

 

[Trevor G]

I am not sure what version of Access you are using, but if 2007 or higher in the macros section you can use "CopyDatabaseFile" as an action.

If you want this done when no one is in I would ask the System Administrators to set up a schedule time like 4am to run this task automatically.

I hope this helps you.