G
Guest
what is the max number of users for an Access 2000 database???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Have you looked in the help files or read previous posts in this newsgroup?
This question was just answered yesterday. The actual limit is 255
concurrent users. The practical limit depends on the network, what they are
doing, how large the data is, etc. If you have a bunch of read-only users,
you can probably have more. If you have heavy users running complex queries
or adding/changing a great deal of records, then you may run into issues
with more than a few users.
In general, you should be able to have 30 to 40 users with a typical
database and a good network without too much trouble.
This question was just answered yesterday. The actual limit is 255
concurrent users. The practical limit depends on the network, what they are
doing, how large the data is, etc. If you have a bunch of read-only users,
you can probably have more. If you have heavy users running complex queries
or adding/changing a great deal of records, then you may run into issues
with more than a few users.
In general, you should be able to have 30 to 40 users with a typical
database and a good network without too much trouble.
R
Rick B
That post from yesterday is in the "security" newsgroup. The subject is
"No. of Users and Data Security".
"No. of Users and Data Security".
G
Guest
Thanks much!
Rick B said:Have you looked in the help files or read previous posts in this newsgroup?
This question was just answered yesterday. The actual limit is 255
concurrent users. The practical limit depends on the network, what they are
doing, how large the data is, etc. If you have a bunch of read-only users,
you can probably have more. If you have heavy users running complex queries
or adding/changing a great deal of records, then you may run into issues
with more than a few users.
In general, you should be able to have 30 to 40 users with a typical
database and a good network without too much trouble.
L
Larry Linson
Frail at Access said:what is the max number of users for an
Access 2000 database???
Access in a multiuser environment:
Factors in how many users can be supported in multiuser include the
requirements, design, and implementation of the database application and the
hardware, software, and network environments. If all factors are near
perfect, we have reliable reports of over 100 concurrent users. Even if not
all are near perfect, we routinely see reports of 30 - 70 users. But, in
cases where we are rather sure that all are about as far from perfect as can
be, people have reported Access "falling over" with as few as four users.
I'd venture to guess that if someone went out of their way to do everything
wrong, it would be possible to create a database that wouldn't even support
one or two users. <GRIN>
Access MDB/MDE as the client in a client-server environment:
Because you have a copy of the Access client on each users machine, with
just one user, the limit would be determined by the number of concurrent
connections that you can have with the server machine or database, and the
capability of the server database.
I have worked with Access clients to server databases which supported just
under 200 users. Others have reported supporting user audiences in the "low
hundreds" as well. My guess is that just was the largest number they had
occasion to have in the C/S environment. I'm sure that most of the clients
with whom I've dealt in recent years would use a web-based application if
they anticipated more users than a few hundred.
Access ADPs should have no more limits than using an MDB with ODBC, but they
are no longer recommended as the "method of choice" for Access
client-server.
Larry Linson
Microsoft Access MVP