[AccessD] MS Access and data-driven websites

jwcolby jwcolby at colbyconsulting.com
Fri Jun 22 17:12:59 CDT 2007


One of my favorite quotes, which I always mangle...

The DBAs / programmer's job is to outwit the idiots.  The universes job is
to create better idiots.  Who has been on the job longer?

This is a shining example that the universe is pretty good at creating
idiots.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Friday, June 22, 2007 6:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [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.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list