how many users can access

  • Thread starter Thread starter Van T. Dinh
  • Start date Start date
V

Van T. Dinh

If your database is well-designed / implemented, and your
network hardware / software are good, that shouldn't be
any problem.

However, JET does NOT have a proper back-up / restore
procedure. Sometimes, corruptions do occur which takes
time to fix. Think this way: can you afford X numbers of
workers NOT working efficiently becasue the database is in-
operative for 1/2 a day or a full day. If you can't,
suggest you move up to a proper databaser server like MS-
SQL Server (NOT MSDE, the limited version of MS-SQL
Server) and use Access as the Front-End only.

HTH
Van T. Dinh
MVP (Access)
 
Is anyone out there running with 50 or more users. If so, how is it
working out? What types of problems have you had?:)
 
Yes, there are reliable reports in the newsgroups of people running with
30 - 70 users, with adequate performance, even if not all factors are
near-perfect. If all factors _are_ near perfect, we see reliable reports of
100+ users.

But, there are many factors, including the hardware, software, and network
environment, and the requirements, design, and implementation of the
application. If all are about as far from perfect as can be, we've heard of
"Access falling over with four users", and I suspect someone could make it
so bad that it would not even run with a single user if they _really,
really_ tried.

Those factors can vary so much, in theory and in practice, that it just
isn't possible to predict.

One thing I _can_ predict... if you think there are going to be 50 users,
that is almost certainly just a start. In many years in the computer
business, I can't recall a single user audience size estimate that didn't,
in fact, grow to be a t least twice as large as the original estimate.

I remember working on one project which, when I started working there in
1995, had 35 users and the customer's project administrator said, "There'll
never be more than 50 users." Fortunately, other factors dictated that it
had to be a client-server application rather than an Access-Jet multiuser
application -- I say fortunate, because when I last did any work on it, in
2000, there were just under 200 users.

Larry Linson
Microsoft Access MVP
 
Back
Top