Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / November 2003

Tip: Looking for answers? Try searching our database.

What is max number?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jane - 18 Nov 2003 07:32 GMT
What is the maximun number of users who can use an Access
2000 database at the same time?  Someone told me 5 to 8,
is this true?

Jane
Van T. Dinh - 18 Nov 2003 11:21 GMT
The JET Database Engine has a limit of 255 users.  The working limit is much
lower than that.  However, the working limit depends on how well the
database is designed and implemented, how dynamic the data is, your network
hardware and software.  However, 5 to 8 is certainly too low.  I have a
number of databases with 20+ users without problems and it was reported here
that an Access database worked quite well with 100+ users.

--
HTH
Van T. Dinh
MVP (Access)

> What is the maximun number of users who can use an Access
> 2000 database at the same time?  Someone told me 5 to 8,
> is this true?
>
> Jane
Larry  Linson - 19 Nov 2003 05:09 GMT
>  I have a number of databases with 20+
> users without problems and it was reported
> here that an Access database worked quite
> well with 100+ users.

My guess is that where there are 100+ users, every factor was
"near-perfect". I'd also guess that one of the near-perfect factors was the
application's requirements, with a high ratio of read/view to update
activity. BTW, because of the reputation of the people reporting the 100+
user DBs (Kaplan, Groh, and Forte, to cite just three), I believe those
reports.

In the days of Access 2, I'd start to get edgy when a client talked about 20
or more users, and downright uncomfortable when they talked about 50. But
30 - 70 users with adequate performance seems routine in 32-bit Access, and
even more is not all that uncommon.

One reason to be edgy when the estimate for number of users seems on the
high side is that, in over 40 years in the computer business, I never
encountered an initial user estimate that did not at least double during the
life of the application. On one Access project (fortunately a client-server
arrangment for reasons of reliability and recoverability), when I came on
board the project in 1995, the client's project administrator said, "35
users, never more than 50". When I last worked on that project in 2000,
there were just under 200 users, and more being added every week. So much
for firm estimates! (And, just for the record, the same held true in my
previous incarnation as a mainframer... figure at least twice as many users
as estimated, and maybe many, many more than that.)

 Larry Linson
 Microsoft Access MVP
Van T. Dinh - 19 Nov 2003 14:50 GMT
Personally, I start advising my clients to look at upsizing to database
server at around 20+ users since if a database is used by 20+ users, I think
it is important enough to have proper back-up and restore procedure.

--
HTH
Van T. Dinh
MVP (Access)

> My guess is that where there are 100+ users, every factor was
> "near-perfect". I'd also guess that one of the near-perfect factors was the
[quoted text clipped - 22 lines]
>   Larry Linson
>   Microsoft Access MVP
Larry  Linson - 22 Nov 2003 05:27 GMT
> Personally, I start advising my clients to look
> at upsizing to database server at around 20+
> users since if a database is used by 20+ users,
> I think it is important enough to have proper
> back-up and restore procedure.

Over half the paying work I've done with Access has been client-server. The
choice of client-server over multiuser, in many of those cases, was based on
reliability and recoverability, not on number of users. It was always one of
several "real" server databases, though, not MSDE, which is purposely
limited.

  Larry Linson
  Microsoft Access MVP
Mike Dwyer - 21 Nov 2003 22:17 GMT
>What is the maximun number of users who can use an Access
>2000 database at the same time?  Someone told me 5 to 8,
>is this true?
>
>Jane

I've had 100+ users hit an MDB with good success.  However, there
wasn't much updating--mostly reading.  With MSDE being included for
free and the cost of SQL server coming down, it really is worth the
effort to move to that platform.  You will sleep better knowing that
your MDB is much less prone to corruption.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.