Back Up a database upon exit or on a schedule

  • Thread starter Thread starter zmenloans
  • Start date Start date
Z

zmenloans

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!
 
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."
 
Back
Top