If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Back Up a database upon exit or on a schedule
Hi,
I'm trying to create a macro that will back up a database every time the user exits. Or (which might even be better), I'd like the databse to back up every Friday evening. The database I have is shared and can be used by 10 people at the same time. If there is a way to create a macro upon exit, I would only want it to back up when the last user exits. I hope this makes sense. I'm working with people that aren't very computer savvy (and neither am I) and they would forget to do the manual back up unless there was a button there (like a macro). I welcome any input whatsoever. Please be patient and detailed as I am a new Access user. Thanks! |
#2
|
|||
|
|||
Back Up a database upon exit or on a schedule
zmenloans,
Windows has a Task Scheduler. You can create a .bat file to copy any .mdb files you want to any backup device. These can run via the Scheduler... every night, or at any interval you choose. Also... many freeware and shareware Backup utilities are available, and can be set up to back up any files, at any time. I use Cobian Backup (free) to back up all my Access .mdb "working" files twice a day. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "zmenloans" wrote in message ... Hi, I'm trying to create a macro that will back up a database every time the user exits. Or (which might even be better), I'd like the databse to back up every Friday evening. The database I have is shared and can be used by 10 people at the same time. If there is a way to create a macro upon exit, I would only want it to back up when the last user exits. I hope this makes sense. I'm working with people that aren't very computer savvy (and neither am I) and they would forget to do the manual back up unless there was a button there (like a macro). I welcome any input whatsoever. Please be patient and detailed as I am a new Access user. Thanks! |
Thread Tools | |
Display Modes | |
|
|