Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2001
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maximum number of users (Access 2000)

    Is there a limit to the number of people who can use an access database at one time on a Novell 5.1 network? We have an Access database in use by about 50 people and we often get messages that the database cannot be found.

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

    Re: Maximum number of users (Access 2000)

    As far as I know, there isn't any limit that would cause Access to behave in a different fashion on Novell - unless there is some maximum number of users that can be connected to a specific file. There are two files involved with an Access database (if it's split it may be three different files) - the .MDB file which stores at a minimum the data tables, and the .LDB file which stores lock information. The latter is a temporary file created when the first person opens the .MDB file, and it is normally deleted when the last person closes the database. If you are having network problems then you might either have locking problems, or you might get messages that the connection to the database has experienced an error. Let me suggest that you post the actual error message verbatim that you are getting - or if you are getting different ones, post all of them.

    As a maximum, the most users that can have a database open is 255 - but in practice, once you get to 30 or more we usually recommend SQL Server. It does however depend on a number of variables such as how frequently users access data, how frequently they update or add new data, how critical the database is to day-to-day operations, how large the frequently used tables are, and the like. So in some cases, a 10 user database should move to SQL Server, while a relatively inactive one may support 100 or more potential users.
    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
  •