MS Access Cocurrent Users

[TWTCommish]

How many concurrent users can MS Access 2000 handle online? I've heard it place between 2 and 30.

[freddydoesphp]

From my experiences it has been towards the lower end of that range. The really low end.

[TWTCommish]

You kidding me? Only a few at a time?

[big_al]

Hi,

I think it's about the 25 mark. With a normal connection lasting about 80-180ms you would have to ahve a fair amount of hits to get up to that mark.

[DaveMaxwell]

Big_Al is absolutely right. You would have to have 25 users performing access on the database at EXACTLY the same time. That would mean you would need a couple hundred at the exact same time to have a real impact on the database.

If you use Access2000, the number is higher and with the faster response time with the JET drivers, your chances of 25 or more users hitting the database is even lower....

[TWTCommish]

Ah, I see. Thanks then -- that's what I needed to know.