Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page