Maximum Number os Users Supported by Access

[zambian]

Hi,

What is the maximum number of users that Access can support in a client server environment ?

Thanks for ur time..

Hemang

[Clunietp]

ZERO

That was a trick question: MS Access is not a client/server DB

If you meant how many users can you support if you stick the MDB file on a network share, then you can probably get up to 10 concurrent users, although M$ recommends < 5

[Serge]

We've tried 13 people and Access choked. It just couldn't handle it. If you need database to be used between many users, then consider Client/Server database like SQL Server, Oracle, Sybase etc.

[Jaguar]

You may want to do some testing. I have had up to 40-50. It was quite slow.

If you are putting it on a Novell Netware server then you need to increase the number of locks on the server to higher than the default. I think it's around 10-15, but if you increase it to 100, then it works much better.

The total number of concurrent users that Access allows is 256. Yes it does depend though on the environment, but there shouldn't be any reason why you couldn't get more that what these other responses tell you.

Test, test, test...