Whats the score with Concurrency?

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi

How many users can Access handle? Everyone I work with is
convinced its 1 - therefore if you need a database for
more than 1 users, Access is not the tool to use.
Anyone care to argue with me about this? I'm curious, and
would like to know how Access handles transaction locking
for multiple users.

Cheers
Tim
 
Tim

It depends on how much action the database is going to handle. If its not a
lot of data and not a lot of query processing, you could potential have more
than 15 users.

We usually stay within the 5-15 users range and then depending on what the
application is doing, we adjust from there.

FMS has a white paper on Access Upsizing to SQL if there is any interest.
http://www.fmsinc.com/fmsupsize/

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
How many users can Access handle?
Everyone I work with is convinced its
1 - therefore if you need a database for
more than 1 users, Access is not the
tool to use.
Click to expand...

They are dead wrong.
Anyone care to argue with me about this?
Click to expand...

No, this newsgroup isn't for argument, it is for information.

IMNSHO, Rob is unduly pessimistic, to wit, 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
 
Back
Top