Is there a way to creat a back up table (in a new file) where the name of the table is the current date?

Maybe you will find this link (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56751) helpful.