Hi adau,
Due to the fact that it depends on a number of factors, there is no
hard and fast number, but I think 30 to 70 users would be a reliable
estimate. Remember, though, that multiple users can access the
database but only one can edit it at a time.
Multi-user Databases with Microsoft Access: How Many Users?:
High-End Reports
* Michael Groh - 150
*Drew Wutka - 135
*Michael Kaplan - 90 +
*Stephen Forte - 95
Routine? Reports
*in comp.databases.ms-access newsgroup
*from experienced Access developers
*30 - 70 users for Access 97 and Access 2000, a few less for Access 2.0
Low -End Reports
*Falls over with 4 users
http://appdevissues.tripod.com/downloads/Developing%20Multi-User%20Microsoft%20Access%20Database%20Applications.pdf
Re: Multi user limits in Access (2000/XP)
"There are a number of factors that enter into multiuser Access/Jet
performance. If all of them are near-perfect, we see reliable reports
of 100+ users; we routinely see reports of 30-70 users; even if all
factors are about as far from perfect as possible, the database will
still usually stand up with a small handful of users.
Any developer who can "crash" Access with two or three users probably
has abominable (1) requirements (2) design (3) implementation (4)
hardware environment (5) software environment _and_ (6) network
environment. If #2 and #3 are awful enough, they alone may crash
Access -- hey, it is possible that they can be bad enough to cause
problems with only a single user."
http://dbforums.com/t506903.html
Additional Links of Interest:
Tony's Main Microsoft Access Page:
http://www.granite.ab.ca/accsmstr.htm
Access 2000 Developer's Handbook, Volume 2: Enterprise Edition
by Paul Litwin, Ken Getz, Mike Gilbert :
http://www.amazon.com/exec/obidos/tg/detail/-/0782123724/qid=1103816401/sr=1-4/ref=sr_1_4/002-3633585-2731264?v=glance&s=books
How many users can use access at the same time????
"Record locking levels should be in place with a multi-user
environment. Only one person can edit a record at a time. With SQL
servers, the last entry will be the edited record. If you are using a
network drive the same will apply. I don't know the number or limit of
users, as we have 14 people in our office using the same database.
Only on occassions when two people are trying to edit the same record
will a warning pop up to advise that the record changes can't be
saved. Then it was just a matter of going back into the record to make
the change. For example, many records require to be signed off as
accepted, if two senior managers are in the same record trying to sign
off, then only one is saved, however with the warning message, they
know to reopen the record and to re-edit the record. So to answer your
question, set record locks and then use the database as you like
regardless if someone else is using it at the same time."
http://forums.devarticles.com/showthread.php?t=11071
I hope this helps. If you have any questions, please post a
clarification request *before* closing/rating my answer and I'll be
happy to reply.
Thank you,
hummer
Google Search Terms Used:
ms access 2000 multiuser environment "how many users"
ms access 2000 multi-user environment "how many users"
MS Access 2000 multiuser "how many users" |
,
0 Comments
)