Results 1 to 2 of 2
2003-03-03, 15:28 #1
- Join Date
- Mar 2001
- 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.
2003-03-04, 00:11 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 58 Times in 58 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