Hi Philip & Neal,
As of Access 2000 you can set an option to have your application compact on
exit but I don't think the product offers to make a backup for you. I think
you get a backup byproduct as a consequence of the compact but it's always
named DBn.mdb and renaming it couldn't be a part of the Access application.
I created a small application several years ago, that I've threatened to get
out there, maybe now's the time. It is designed to handle just Access
files. It copies the target file to a backup root of your naming and then
by /weekday folder and then compacts and restores the compacted file to the
original location.
If you'd like to try a time bounded demo version, please email me with your
own email address. Include the version of Access you are using so that I
can send you an MDE of the right flavor.
HTH
