Hi, Luke.
Will a database be
significantly impaired by having 20-25 simultaneous users?
Possibly. Possibly not. How many of these concurrent users are updating
records, as opposed to just reading records? Updating records requires
record locks, which affects the performance of the database.
The number of concurrent users will be affected by the amount of network
traffic and the amount of record lock contention. The record lock
contention can be controlled to some degree by the efficiency of the
database design and database application's design. This is where
experienced Access database developers are worth their weight in gold,
because they can often create a fairly robust database system with Access,
instead of creating a much more expensive database system with SQL Server,
Oracle, or another RDBMS.
So, the effect on concurrent users depends upon the amount of record lock
contention, the network and how it handles traffic, and the expertise of the
database developer in designing the database application.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
