[AccessD] Access or SQL Server Express to web

Did you ever doubt me? ;)

The ONLY 'absolute' reasons to go to a server side database for web
applications is size (if you're going to eat up a hundred megs a day or
more), EXTREME use (and I'm talking THOUSANDS of TRULY simultaneous
users), and triggers/rollback needs.

With an .mdb stored OFF the website folders (but still on the server),
the database is protected at the OS level, just as strong as a server
side db would be protected.  It only really has one user (the IIS
Server), so the limit of users is out the window, and the amount of work
it will do is limited to the heftiness of the webserver itself (because
to the web application, the IIS Server is using the .mdb locally, so it
will be even faster then sending queries off to another machine).

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Thursday, December 13, 2007 10:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access or SQL Server Express to web

...I know this will get your goat but we've had over 150 users in mdb 
sourced pages simultaneously without a hick-up so far ...I'm in the
process 
of moving to SQL Server because the load will get much larger in the
next 
few months but so far, Drew has been right, Access mdbs can take a lot
of 
abuse on the web ...of course I'll freely admit that its read only and I

cache the hell out of it ...but still :)

...the web based apps all are hosted on shared win2K3 boxes w plenty of
ram 
and dedicated app spaces.

...the largest intranet based app never has more than ten users in it
and 
the average is probably less than five ...the servers are all Dell PE's
w/ 
2GB ram and large Raid5 HDs running SBS2003 Premium R2 ...pretty vanilla
but 
I like vanilla in servers :)

...like I said, I cater to small business owners and tend to keep it
simple 
...something an ignorant lout like me can stay on top of :)

...btw, the MS ajax built into 3.5 works really well compared to that
added 
on to 2.0 ...its a very noticeable difference imnsho, especially in the 
gridview ...the MS sponsored open-source 3.5 ajax controls toolkit
version 
on the other hand, still has some performance problems with some of the 
controls ...two steps forward, one step back.

William