I am creating a .accdb for a friend and would like to include a button on a form that will automatically save a backup copy of the .accdb to a dedicated "\Backups\" folder. Basically, I want to recreate the entire functionality as 'Save As' on an open .accdb, saving it into the backups folder with the date/time appended to its name.

I have been all over the net trying to figure out a way to do this, but keep running into solutions involving FileCopy (or copyfile) which do not seem to work while the database is **open** (which it will need to be since this will be for a form). I don't want to create a 'pseudo backup' where most functionality/relations are removed; I want the whole .accdb, just saved to a different directory and with a slightly different name with a button click. Any ideas?

​