I'm working on a database for a friend and would like to be able to have buttons allowing them to instantly create 1. A backup of the entire database (.accdb) and 2. An Excel workbook containing all the tables in the .accdb with the push of a button. I'm running into trouble trying to set this up.

I have looked into using Macros for this, but exploring all the Actions available (including SaveObject) makes it seem like you can only save individual tables/forms/etc. not the entire database itself. Similarly, while the Macros can export to Excel, they seem to only do this with one table at a time, instead of combining all the tables into a single workbook.

I'm also having a little trouble with establishing the path for these backups; I'd like to have it so they both go to a subfolder in the directory of the .accdb (\Backups\Excel & \Backups\Database) but using ".\Backups" does not work due to my Access having a 'default location' set to My Documents folder (i.e. "." = "My Documents"). The person I'm delivering this too is not too tech-savvy and I'm worried that even if I change MY Access' default directory, hers might still be a problem. I'd like to be able to deliver a folder with the .accdb in it, and have it set up so these backups always go to the "\Backups" folder without having to worry about her moving the master folder around.

Any advice on this would be greatly appreciated. Thanks!