[AccessD] MS Access and data-driven websites

Very True.  It's that kiss of death comment that gets my goat!  I have
nothing against developing in a server side db, but when someone who
claims to be a DBA says that an .mdb run locally on a webserver is
bad....GRRRRR! ;)

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher
Hawkins
Sent: Friday, June 22, 2007 1:18 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] MS Access and data-driven websites

I agree with you guys that SQL Server (especially with SQL Server
Express being so good and so free) is the best choice.  However, I deal
mainly with small businesses and a fair portion of the time, these guys
don't have their own server, don't want to pay to use my SQL Server, or
already have their site on $10/month shared hosting and won't spring for
the extra $5/month to add SQL Server.  Dropping an mdb file into their
webspace is the quick and dirty solution for clients whoare only willing
to pay for quick & dirty.  :)

Of course, the clients who have a little vision and are willing to spend
money on the industrial grade stuff get SQL Server back-ends.  I
recommend SQL to everyone, but some of them balk.  And don't even get me
started on the "fix-it" projects where I have to go in and repair sites
that are underperforming.  Ugh.
The difference tends to be between clients who do not understand the
value their site provides to the business, and clients who do.  I mean
really, $5/month to add SQL to your shared hosting?  For the love of all
that's holy, crawl off the dime.  :p

Anyway, my point was not that SQL Server is not the best choice -
clearly it is; I'm focusing my whole business around it - but rather
that MS Access is not the kiss of death for web back-ends that many seem
to think it is.  

That said, if I never had to do another MS Access back-end again, I'd be
OK with that.

Robert:  I hear you on hosting multiple sites out of one database.  I've
got a database that is serving up content for 8 different sites.  We
tagged every record with a SiteID and it's off to the races!  Good
stuff.

-C-

The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.