Last post Jun 25, 2009 09:07 AM by hans_v
Dec 05, 2008 03:10 AM|srikanthbollineni|LINK
Iam using Access database in my web application. I faced a problem that access database is only allow some specific number of users .Iam using that database as read-only, no updates to data .After reading so many articles in web i come to know
SQL server is best database for web applications which having high stress and concurrency.This SQL server requires licensing but iam not able to spend that much amount.Is there any solution, that access database will work in this kind of situation?
Dec 05, 2008 04:37 AM|kipo|LINK
If you're hosting your web on your own server, you can use free Microsoft SQL
Server Express - there are limitations, but it's better solution than Access. If you're using some hosting provider, they all support Microsoft SQL server, so you don't have to purchase it.
Dec 05, 2008 05:52 AM|Mikesdotnetting|LINK
I faced a problem that access database is only allow some specific number of users .Iam using that database as read-only, no updates to data .After reading so many articles in web i come to know SQL server is best database for web applications which having
high stress and concurrency
The reported "Maximum number of users" with Access can be misleading. Your actual database will only be accessed by one user - the web application itself, and each connection lasts only as long as it is opened then closed. Generally, that's fractions of
a second. All the time that a user is just looking at a web page on your site, they are not "using" Access. I have had similar web sites running fine with Access where there are half a million database reads a month. However, if you are developing a site
that expects "high stress and concurrency", you would be better using SQL Server. It just depends on what levels of traffic you expect.
Jun 25, 2009 07:02 AM|mvark|LINK
While you can use Access for web applications, you may run into issues if you web pages are data-intensive and you have many concurrent users.
Consider moving to SQL Server or try the free Microsoft SQL Server Express edition if cost is a concern.
Jun 25, 2009 09:07 AM|hans_v|LINK
Why are you reopening a topic that's more than half a year old, that's already marked as answered and everything you said is already been said by the others that responded?