Last post Jun 13, 2011 03:19 AM by ram.kvb
Jun 10, 2011 03:03 AM|ram.kvb|LINK
I am new to web development and currently working on a departmental web portal for a client using ASP.NET 3.5 and MS Access 2003. This portal contains functionalities like adding departmental news articles, posting personal articles, displaying employee
birthdays, rating the articles etc.,.
This portal will be used by approx 150 users of the department. My question is does the MS Access 2003 support my functionality. In the sense, multiple users accessing the portal and amount of data being stored into the DB.
Please let me know your comments on this. If there is any problem with this implemention, please let me know the alternatives.
Jun 10, 2011 06:25 AM|Ken Tucker|LINK
Yes you can make a website that uses access as it database. The only thing to keep in mind is access does not work well if you have a lot of users accessing the website at the same time. You would be better off using sql server or mysql if you are expecting
a lot of users to use the web site at the same time
Jun 10, 2011 07:44 AM|ram.kvb|LINK
Thanks a lot for your reply. Any idea on the maximum count of users for which it will work fine ??
I see a lock file getting created every time when i open the DB through my ASP.NET application. Will this lock file affect when multiple users update or read the data at same time ?
Jun 10, 2011 08:04 AM|KumarHarsh|LINK
Jun 12, 2011 08:36 AM|hans_v|LINK
With the amount of users you're saying, Access will do just fine, as long as you keep in mind that you should open the database connection as late as possible, and close it as soon as possible. The best thing is the use the "using" syntax, which will automatically
close and dispose the database connection:
But if you can, you better use SQL Server Express, which is alse free.
Jun 12, 2011 10:17 PM|Decker Dong - MSFT|LINK
As far as I know, the amount of clients——if less, Access will do fine. Though it is, please remember just to relase your memory ASAP (as soon as possible) by using "using（……）block",——like what hans_v's said.
However, if your clients' number is increasing repidly in the future. I strongly recommand you use the standard version or SQL Express, Here you can download and have a try——
Jun 13, 2011 03:14 AM|ram.kvb|LINK
Hi Harsh, Thanks for your reply. I will look into it..
Jun 13, 2011 03:17 AM|ram.kvb|LINK
Hi hans_v, thanks a lot for the reply and link.. since my application users count might not increase.. i think i can go ahead with Access by taking care of DB objects dispose.
Jun 13, 2011 03:19 AM|ram.kvb|LINK
Hi Decker Dong. Thanks a lot for the reply and suggestion for upgrading the DB to SQL Server when user count increases.