ASP / MS Access on an Intranet
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=15199
Printed Date: 30 March 2026 at 5:05am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ASP / MS Access on an Intranet
Posted By: frazerc
Subject: ASP / MS Access on an Intranet
Date Posted: 23 May 2005 at 5:05pm
|
I'm involved in the designing of an Intranet at work and we'd like to use some ASP Scripts (including some Web Wiz ones) to make the site more dynamic. We will have a maximum of 200-250 users accessing the site. I was hoping someone could throw light on how an MS Access database would cope under the strain.
I've read that Access starts to feel the strain when only a few users access these databases via ASP pages.
Is this just as true for a forum script where data is being added all the time, as it is for a news script where data is added once or twice a day? Or can a news script be viewed by more users without experiencing too many problems.
|
Replies:
Posted By: michael
Date Posted: 23 May 2005 at 5:47pm
|
There are multiple discussion on that subject here. Generally try if at all possible to avoid Access, rather go with MSDE. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: xeerex
Date Posted: 23 May 2005 at 6:12pm
|
It depends on how the server is setup. As mentioned before in several
posts, Access strains under "concurrent connections" but otherwise will
generally work fine. My largest forum has over 16k members and currently has 15 active users showing although it has peaked at 160 (active users page) for 8 hours continuously. It is over 1 year old and has run with barely any hitches.  Like michael said though, when the choice is available run SQL Server or the MSDE. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: dpyers
Date Posted: 23 May 2005 at 8:15pm
|
With Access, a weekly compact and repair after a backup does a lot for maintaining performance levels. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: frazerc
Date Posted: 24 May 2005 at 3:22pm
|
Thanks |