:confused: I would like to know how to setup a Macro which Automatically Backs Up the Access Database when it is closed. I would like to set up a different Backup for each day of the week, then the following week I would like it to overwrite the previous backup.

Try the following link:-

http://www.access-programmers.co.uk/forums/showthread.php?t=42293&highlight=automatic+backup