Tags Tags

Can you back-up through a Macro?

August 07th, 2008 - 02:09 pm ET by Marsha | Report spam
Help Create a new topic
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?
email Follow the discussionReplies 1 replyReplies Make a reply

Replies

#1 bhicks11 via AccessMonster.com
August 07th, 2008 - 09:45 pm ET | Report spam
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-...amp;idd689


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

Marsha wrote:
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?



Message posted via http://www.accessmonster.com

Similar topics

Make your own search :