users on db

  • Thread starter Thread starter Gee
  • Start date Start date
G

Gee

I just put together a lovely db to do some stuff for us.
No big calculations, it's basically telling us what was
done when to particular machines.
The problem is that someone at a manager's meeting told my
supervisor that if there are 10 users you're fine, but the
11th will cause a crash.
How true is this?
 
The problem is that someone at a
manager's meeting told my super-
visor that if there are 10 users you're
fine, but the 11th will cause a crash.
Click to expand...
How true is this?
Click to expand...

It is not true, as a rule, but it is -possible- for someone to do such a
poor job of designing and implementing a database that it might be true for
a particular database. See the following:

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>

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
 
Thank you very much!
-----Original Message-----



It is not true, as a rule, but it is -possible- for someone to do such a
poor job of designing and implementing a database that it might be true for
a particular database. See the following:

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>

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP


.
Click to expand...
 
Back
Top