Backup database automatically

[Guest]

How do i get access to back up automatically - can access actually do this or
does it have to be done manually ?

Im paranoid about losing the database !

 

[Guest]

Hi Phillip - No Answer to this - but i was thinking the exact same question -
did you get any responses?

 

[Larry Daugherty]

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