Link to home
Create AccountLog in
Avatar of Patrick O'Dea
Patrick O'DeaFlag for Ireland

asked on

How many concurrent users in an active database?

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?
SOLUTION
Avatar of Gottler
Gottler

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
"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
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Patrick O'Dea

ASKER

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
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.