Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to Auto Backup MS Access 2003/VBA Program

Discussion in 'Information Technology' started by Beartenor1, Jul 28, 2006.

  1. Beartenor1

    Beartenor1
    Expand Collapse
    Guest

    Twice now I have lost an entire day's programming because I failed to create
    a backup before my computer crashed.

    How do you set up MS Access 2003/VBA to auto backup at specified time
    intervals?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Beartenor1" wrote

    > Twice now I have lost an entire day's
    > programming because I failed to create
    > a backup before my computer crashed.


    Gee, I don't believe it took that much incentive to convince me to manually
    copy the database (frequently) I was working on to an archive. I pick a time
    that balances between wasting effort by saving too frequently and recovering
    if I crash. If I am working using Windows API, which is likely to take the
    system down if I make an error, I'll save even more frequently.

    When I add VBA code, I usually compile and save before testing it, because
    the VBE does not prompt for saving. Again, it only took a couple of
    "un-Break-able" application hangs to learn this was A Really Good Idea.

    > How do you set up MS Access 2003/VBA
    > to auto backup at specified time
    > intervals?


    Unfortunately, that is not one of Access' features.

    Larry Linson
    Microsoft Access MVP
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Beartenor1 <Beartenor1@discussions.microsoft.com> wrote:

    >Twice now I have lost an entire day's programming because I failed to create
    >a backup before my computer crashed.
    >
    >How do you set up MS Access 2003/VBA to auto backup at specified time
    >intervals?


    I copy and paste within Windows explorer every time I finish up a
    significant piece of logic or whatever. I can have two or five copies
    a day. I archive them off to CD every few weeks. As well as making
    a backup every few days.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  5. rajesh

    rajesh
    Expand Collapse
    Guest

    Re: How to Auto Backup MS Access 2003/VB Program

    hello sir,
    i am working at one software company.i developed one project for
    maintaining student record by use of VB and MS Access. now i need how
    to take the back of records in table from MS Access.

    yours lovingly
    kannan.s
     

Share This Page