By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Number of Users in Network Environment

BradHodge
Expert 100+
P: 166
Reading a post regarding network security on a linked database, I saw this post by PDog on number of users in a network Environment...
Access Databases on a Network

Generally, Access can handle up to 50 concurrent users over a network without any trouble, but there are other issues to consider:

Does the server and do the client PCs have enough grunt?
Is LAN broadband sufficient?
How big is the database?
How is it split?
I am about to put a very small database (2200 kb back-end) out on the network. I am expecting 75-100 users in the system at any one time. The database is largely Read-Only (with the exception a few record changes made daily).

I have had it in use by ~20 users continuously for the last 6 months, and have had no trouble.

The database is written in Access 2000, and will be run on 99% XP machines. The users PCs will have anywhere from A2K to A2003. Some also will be using RunTime because of no Access or A97. The server is running Windows Server 2003.

Thoughts on what I will run into with the increase of users?

Thanks,
Brad.
Sep 4 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Reading a post regarding network security on a linked database, I saw this post by PDog on number of users in a network Environment...

I am about to put a very small database (2200 kb back-end) out on the network. I am expecting 75-100 users in the system at any one time. The database is largely Read-Only (with the exception a few record changes made daily).

I have had it in use by ~20 users continuously for the last 6 months, and have had no trouble.

The database is written in Access 2000, and will be run on 99% XP machines. The users PCs will have anywhere from A2K to A2003. Some also will be using RunTime because of no Access or A97. The server is running Windows Server 2003.

Thoughts on what I will run into with the increase of users?

Thanks,
Brad.
It will vary from database to database. Technically you are allowed up to 255 concurrent users but at a certain point the preformance of the database will slow down. Only by trying it will you be able to tell for sure.
Sep 5 '07 #2

BradHodge
Expert 100+
P: 166
Thanks Mary. I'll give it the old college try, and if need be, will switch to a SQL backend.

Thanks.
Brad.
Sep 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.