Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Backing up a Database (2000)

    I have a database that has been split. Both the front and back end is an Access database. There will be times during the use of the database that as many as 10 to 15 users will be adding information at the same time. Because the information is important and because the tables will be changing quickly, I want to make frequent backups of the tables. Making a batch file to do the backups is no problem but I'm wondering if the tables can be backed up while they are open and in use. If not, any suggestions?

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

    Re: Backing up a Database (2000)

    It may depend on the OS - it seems to work OK with Windows NT4 or Windows XP Pro on the desktop PC's and Windows 2000 Server on the file server.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backing up a Database (2000)

    Although all of this will be networked, it will only be peer to peer. The tables will reside on an up-to-date Windows 2000 workstation. Do you think that will be ok?

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

    Re: Backing up a Database (2000)

    You will be at the upper limit of what you can do at that user load. If it's heavy-duty data entry, you may see it get sluggish, especially if there are others trying to access records as well. In addition, Windows 2000 workstation starts to throttle things as I understand it when you get up to 15 or 20 connections to it. I would suggest you take a hard look as Small Business Server - it gets you a single domain controller and SQL Server (which has much more robust backup facilities). It does require some care and feeding however.
    Wendell

Posting Permissions

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