Excel: Automatically Backing Up An Access Database at a Particular Time

I have an Access database that I would like to back up automatically either on the network drive (or an online storage place would be best...dropbox?). My database has tables, queries, forms, reports, macros, etc so the ENTIRE database needs to be backed up. I would like to backup of the database to occur at a specific time, say 1AM every day, or once a week, say Fridays at 1AM. This is a multi-user database so before the back up runs, it will need to check if there are any users that has the database open, and if there are then it should automatically boot the user after 5 mins and then run the back up. I've heard VBA or running some batch file will do the job. I have very little experience in both. TIA!

This question generated 49 answers. To proceed to the answers, click here.

This thread is current as of August 07, 2014.

For more resources for Microsoft Excel