How to handle "attack" from web users to backend MS Access db

I have been wondering for days but couldn't find a satisfactory answer.

What happens when more than one web users simultaneously access ( 1 in million chance!) a specific .aspx page driven by MS Access db? Does the web app. crash...or even corrupt the db?


If so, how to prevent it from happening? (by coding? reconfig IIS Database Connection?)


What got me worried is the Locking file dynamically gen. by MS Access each time when doing db operations...



Any help is appreciated!

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

You should be ok in that scenario. You'll run into problems when more users start to access the db, or when it becomes accessed more frequently.


When this happens you can upgrade to sql.



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Thanks , Joel!


I agree...that's the time for my boss to spend $$$ on SQL add-on

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

Hi

Not sure if this is of any help but I used to run quite a popular website a couple of years ago and at one time it had over 600 users online and I ran it off an Access DB with no problems so you should be ok - that was using classic ASP.

Hope that re-assures you

 

Hello

I used to run www.terminator-3.co.uk - a fan site for T3: Rise of the machines (no longer active). I started off the site staticbut then I realised that if I recruited some news reporters and made the site dyanmic I could keep up the news as regularly as the other big players (like comingsoon.net/DarkHorizons.com etc). Anyway, I also started to badger sony Pictures for some exclusives and they came through by giving me the heads up on the International trailer (footage was sparse at this stage).

Anyway - word got round very quickly and the site got hammered! After then, my site was established as a reliable source of information andI constantly had about 200 users online at anyone time and as I mentioned previously, I never experience any problems. The only thing that really hurt me was the $250 bandwidth bill I was getting but that was in the days when bandwidth allocation was a bit stingy.

So, good luck in your venture - you shouldn't have anything to worry about

 

Thanks again, Georgio!


I will definitely refer to your experience with MS Access DB driven website for future reference to anybody who is questioning its reliability..





I was thrilled by your personal experience with such a amazing website of yours.


(I wish someday my website can be as popular as yours )





Good luck in your career!

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

Thx, Georgio!

Finally, I got an answer! Thanks so much for your info.


Hehe....now I can be a little bit relax and set back to enjoy my coffee during my break without ppl bugging me about this issue..


I m interested in what attracts600+ users to hit the same page.

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>