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?
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 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
