CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> General -> Web Design


Print topic Send  topic

Author Message
Posted: 10/06/2005, 6:25 AM

Is anyone using MS Access as a web db? If so, what's the maximum number of simultaneous users you are handling? In other words, how many users can Access gracefully support before we need to upsize to another db like SQL Server or MySQL?

Thanks for your opinion.

Posts: 5971
Posted: 10/06/2005, 10:48 AM

Based on MS Access (JET) supports maximum of 255 users, but recommended for up to 20 total users.

Based on "Sorry to disappoint you, but there is no such magic number. There are far too many variables involved..."

Based on our own tests we could have 10 concurrent users couple years ago but haven't run into this limit after moving to a new Windows server. We still use MS Access on our support site at , without problems.
However we occasionally archive parts of the database (move partial data into another database) because otherwise some SQL search queries take more and more time when the .mdb file grows.

Also keep in mind that you can have thousands of simultaneous users if they are not very active. It is rather the number of simultanous queries that may limit you, so when one user is running an SQL query then other users may wait until that query is finished before they see their Web pages. If each user is displaying just one record then probably the query will take only a split of a second and none of the users will have noticable delays.

See for a previous related discussion.
Peter R.
YesSoftware Forums Moderator
For product support please visit
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.