Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    # of Users - A2K

    Does anyone know, from experience OR reference the number of simultaneous users of a networked Access 2000 database for (1) simultaneous editing of records ? and (2) simultaneous viewing only of data ?

    Thanks for your help.

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

    Re: # of Users - A2K

    The answer always depends on the exact situation. Since you're talking multiuser, the network itself is a major issue in this. Then there's the type of record locking scheme you want to use and the way the application is designed. And of course, it depends on whether you're using a Jet back end or MSDE/SQL Server. It isn't really a simple question and answer.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: # of Users - A2K

    I figured it would be theoretical or best guess. But would like a number if possible. It looks like the database will reside on a network in its standard format, accessible through VPN to the Internet. It will not be a Sequel Server system as we know now. Any any other suggestions greatly appreciated as well.

    Thanks for answering.

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

    Re: # of Users - A2K

    It's going to depend a lot on the speed of the connection to the server, the internet connection, the speed of the individual machines, and on the way the database was designed. I don't have any experience with internet access to a database like this, so I can't be of much help.
    Charlotte

Posting Permissions

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