Results 1 to 3 of 3
  1. #1
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Number of users (97)

    Hello All,

    How many users can work together in 1 Access Database without getting performance problems?
    Greetings,

    Patrick Schouten
    (The Netherlands)

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Number of users (97)

    It depends on how the database is designed, how the network performs, what the various users are doing, and whether they're all doing it at the same time. In 97 on an NT network and with an app designed to be used by multiple data entry operators at the same time, performance starts to deteriorate noticeably after 4 users.
    Charlotte

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

    Re: Number of users (97)

    As Charlotte notes, it all depends on what your users are doing and how you configure the database. If you have 4 or 5 people doing data entry all day long and nothing else, that's about the upper limit. On the other hand if your users are looking at a record occasionally, and making updates once or twice a day, we have some clients running upwards of 100 users on a Jet database. There is an upper limit of 255 simultaneous users, but we start pushing people toward SQL Server or another industrial strength database once they have more than about 10 simultaneous users, regardless of how they use it - we've just convinced one of our large clients with 130 users to migrate to SQL. There are other issues that push you that way anyhow, as backups and recovery issues, and crash resistance are important issues if you are dealing with a mission critical system. Hope this adds some insight.
    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
  •