How many concurrent users in an active database?

Patrick O'Dea
Patrick O'Dea used Ask the Experts™
on
Hi,

(Nothing new in this question)

Access 2007.
What is the recommended MAXIMUM number of concurrent users?

Not a great deal of traffic per user - slightly less than average.

Any views?

a.k.a. How long is a piece of string?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Access allows up to 255 Concurrent users. I would recommend 30 based on your DB size.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
Answers here will be all over the map.
The max per Access spec is 255.
I have > 125 simultaneous users in some databases here at work running over a 1Gbit Fiber Optic WAN network with no issue.

There a many, many factors why 'your results' may vary :-)

mx
Commented:
The technically precise answer to your specific question is "it depends".

On a tangent note, if your database file sizes are small enough that you're still using Access but you're worried about high levels of concurrent users, give serious consideration to SQL Server Express or Oracle XE either of which is better at high concurrency than Access.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"The technically precise answer to your specific question is "it depends"."
LOL.

I technically definitely agree with that :-)

network / stability
hardware
db design
type of db activity (typical)
and .... more ...

mx
Most Valuable Expert 2012
Top Expert 2014
Commented:
As Joe said, you'll get answers all over the board ...

In my experience, databases that are heavy on data entry seem to support fewer users. Databases that are more geared toward reporting data (either through reports or forms) generally can support more users.

For data entry, I generally start to see significant performance issues when the user count hits around 25 or so. For reporting apps ... it depends.

As someone else said, if you're concerned with the number of users, you can always upsize to SQL Server. It's not painless, and it's not a magic pill, but in general it's a fairly simple upgrade, and can help with performance issues.

Author

Commented:
Thanks all,

As I indicated in the question ..... "How long is a piece of string"....

Well now I know !

The answer is : "It Depends" :->

I appreciate the responses
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
I'll add in basically along Scott's comment; 30 or 40 for a typical read/write app.

If reporting only, you can go right up to 255.

And of course we would be remiss in pointing out that this is with JET.   If Access is used as a FE to SQL Server, then sky's the limit (well actually your pocket<g>).

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial