[AccessD] Backing Up Access MDB

A2k3 has a backup option under Tools / utilities.  Whether it will help with users connected I am unsure!
Kind regards,
Dr David Hingston
Director
Chequers Software Limited
Wellington, New Zealand.
www.cheqsoft.com
Crafters of:
Break Reminder - For safe and efficient PC use - www.breakreminder.com
TimesOwn - International Time Zone Calculator a click away - http://www.cheqsoft.com/timesown.html
Clipboard Express - Cut and paste storage and web form filler - http://www.cheqsoft.com/clipboard.html
MP3Detective - MP3 Player manager - http://www.cheqsoft.com/mp3detective.html
Engines2Go = E2Go Fast and friendly Internet searching - have you tried it? http://www.E2Go.com/
  ----- Original Message ----- 
  From: A.D.Tejpal 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, December 10, 2003 5:26 AM
  Subject: Re: [AccessD] Backing Up Access MDB


  Paul,

      You might like to take a look at Access Add-In named SelfSaveAddIn.mda available at Rogers Access Library (Other Developers Section).

      Once installed, you can create compacted backup copies from within the running db at the click of a button (without having to close it first). If it happens to be a split db, compacted backup copy of the back end also gets created simultaneously.

      Following options are available for stamping the backup copies (over & above the basic suffix of "_Bk") -
          (a) Current date and hour
          (b) Current date
          (c) No stamp

  Regards,
  A.D.Tejpal
  --------------
    ----- Original Message ----- 
    From: Dan Waters 
    To: 'Access Developers discussion and problem solving' 
    Sent: Tuesday, December 09, 2003 21:09
    Subject: RE: [AccessD] Backing Up Access MDB


    Paul,

    If you only need to back up the data, perhaps you could just manually copy
    the data tables from the operating mdb to a different mdb?

    What I've done before is to time my mdb changes (or backup) during lunch
    when most people are out of the system, and won't mind if you log them out.

    HTH,
    Dan Waters

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
    paul.hartland at fsmail.net
    Sent: Tuesday, December 09, 2003 6:38 AM
    To: accessd
    Subject: [AccessD] Backing Up Access MDB

    To all,
    We are coming upto our busiest period (January), and we will have about
    15-20 users on Access at any one time.  Is there a way to backup the mdb
    file without taking users out, without the risk of losing any data ? Paul
    Hartland Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50
    a month 
    www.freeserve.com/anytime 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com