Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Phoenix, Arizona, USA
    Posts
    265
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Automagically backup (2003)

    Is there a relatively easy way to backup a database once a week - without anyone having to do it by going to Tools > Database Utilities > Back Up Database? i.e. say from the Autoexec macro?
    Ed
    "Somebody left the cork out of my lunch." - W. C. Fields

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automagically backup (2003)

    It usually isn't a good idea to do something like that automatically on opening the database. If you happen to open it to do some necessary work and your "automagic" operation starts running without so much as a "may I", it can cause problems, emotional if not database related. <img src=/S/ouch.gif border=0 alt=ouch width=15 height=15>
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Automagically backup (2003)

    You have several options for doing backups, though as Charlotte notes, doing them automatically requires some caution. First, there is a commercial utility from FMS called Total Agent that does a number of administrative tasks, including backups. Second, you can write some code to do backups from another database - the thread beginning with <post#=392304>post 392304</post#> deals with this issue. Finally, you can use a file backup utility program to make scheduled backups, as Access .MDB files aren't normally locked - I like a program called Second Copy.
    Wendell

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Phoenix, Arizona, USA
    Posts
    265
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Automagically backup (2003)

    Thanks to you both, I sort of expected this type of a response - but I had to ask. I was just hoping that there was an easy way to insure that there was another copy of the database that was not too old squirrled away in another place. Thanks for your pointers on doing things without some sort of notification to the users.
    Ed
    "Somebody left the cork out of my lunch." - W. C. Fields

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •