Can you back-up through a Macro?

[Marsha]

Hi I have created a Form, so that in the future users of my database can do
what they need to do by "push button" commands. Because I don't know VBA,
I've just used command/control buttons and linked these to Macros. I've been
able to do everything to EXCEPT:

Create a button to back up the database. Because I want users of the db to
only interact with this "push button" form in the future, and I want the db
to be backed up everytime as the final step, I really want this button to be
on there. Does anyone know if there is is a way to write a Macro to back-up
your database? I'm in Access 2003. And if you can't do it in a Macro is
there another way to link it to the button?

 

[bhicks11 via AccessMonster.com]

Hi Marsha - I found this thread about auto backing up. It seams to have
caused an argument but the bottom line is it is more reliable to backup (or
copy) an mdb when it is closed.

http://bytes.com/forum/thread424790.html

Also, here is a free tool that someone offered to backup. You would have to
run this after exit also. Maybe you could use the Windows scheduler to run
it.

Here is a good article by Kevin Sparks about not corrupting your database:

http://ezinearticles.com/?5-Simple-Tips-to-Prevent-MS-Access-Database-Corruption&id=64689


Bonnie
http://www.dataplus-svc.com