Saturday, November 19, 2011

How many concurrent users can Microsoft access handle?

hi





I am looking forward to build a survey tool for my internal oragnization in my company





So i was wondering if i build asp.net driven front end and microsoft access as backend.





No of employees taking survey would be approximate 1000.





and DB should be able to handle concurrent request at the busiest hour of the week e.g. Friday 12-5 or Monday morning around 8-12.





Can access handle such rush ? or any other solutions suggestions are welcome too :)

How many concurrent users can Microsoft access handle?
Another poster answered your question well. I'd like to add that if you indeed do go with access, you can expect to get 5-10 concurrent users up and running before msaccess becomes unstable and/or slow.
Reply:If you are familiar with SQL you can use Microsoft SQL Express 2005 (which is free) for a much more robust back end. 1000 users hitting an access DB won't be great in terms of speed or data integrity so maybe you can space them out in teams of 200-300....


No comments:

Post a Comment