Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DB Backup/Update (2k)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    now that i have a live database on the network, people are always using it. but theres one problem with that, i can't add columns to the tables because they are in use. is there a way of locking out all users for a few minutes so i can do the necessary column updates?

    Also, i want to be able to back-up the database automatically every week or so, does anyone know of a safe way of doing this while users are connected? i found another thread that directed me to this link: http://support.microsoft.com/default.aspx?...amp;Product=acc
    would that be the recommended way of backing it up while users are connected?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DB Backup/Update (2k)

    check out
    http:// http://www.rogersaccesslibrary.com/downloa...LogUsersOff.mdb
    from Roger's access library.

    I have not used it myself , but it is described as :

    This sample illustrates how to automatically log all of your users out of an application for maintenance purposes.

    There are several pieces:

    1) code in the switchboard form OnTimer and OnLoad events

    2) a linked table called 'Settings' with only one Yes/No field called 'Logoff'

    3) frm_ExitNow modal form

    4) code in frm_ExitNow OnTimer and OnLoad events

    When you change the value of Logoff in the Setting table to Yes, the users will get a message on the screen telling them that they will be logged off in 5 minutes. The Switchboard form checks this field every 5 minutes and launches the message form. If they still have not logged off after another 5 minutes, they will be automatically logged off. It will also not allow anyone else to log into the application until Logoff is set back to No.

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

    Re: DB Backup/Update (2k)

    The response by Zave is a good suggestion in response to your first question. And the article by Microsoft is one way of doing a backup, though I would suggest you might want to consider backing up much more frequently than once a week. Access databases can and do go corrupt, and asking people to re-enter data they put in a week ago won't make you very popular. You might want to look at a back-up utility to manage the files - for example FMS has a rather sophisticated product to do backups and compact/repairs as well as a product that lets you do administration and maintenance.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB Backup/Update (2k)

    If you can schedule backups to be made at a time when nobody is using the database, for example in the middle of the night, that would be best. If that is not feasible, use one of the methods described in the MSKB article. They operate at a lower level than the VBA FileCopy instruction so they can copy a database that is in use. I have never experienced a problem when using them, but I suppose a glitch could occur in rare occasions.

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DB Backup/Update (2k)

    thanks guys, all those suggestions were very helpful
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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