Access works just fine if you are expecting less than 50 people to be logged
on at the same time (I believe the 'official' limit is 255, but I wouldn't
want to test that number:>)

Actually if you develop in Access you can always upgrade to SQL server at a
later date.

Frank
----- Original Message -----
From: "Peter Schonefeld" <peter.schonefeld(at)bigpond.com>
To: "Hank Marquardt" <hmarq(at)yerpso.net>
Cc: <hwg-techniques(at)mail.hwg.org>
Sent: Monday, September 10, 2001 9:49 PM
Subject: RE: publishing from a database (MS Access Database)


> Hi,
>
> I must agree that MS Access is not an industrial strength
> database, but i have seen it used as the data store for
> applications (web, network or standalone) for the best part
> of a decade.
>
> In my experience, if the site load is relatively low and the
> database is backed up, compacted and repaired on a regular
> basis, Access will do the job.  The way you code can also
> have an effect on the database performance.
>
> Having said that, i make certain that when entering into a
> contract involving Access development that i explain that
> the database is the weak link in the application - Have you
> considered installing MS SQL Server?
>
> In terms of standard SQL syntax and functionality (not
> performance and reliability) MS Access will handle most
> needs.  But, if you need to tap into the programming power
> of SQL, move to something fully featured.
>
> This link points to an objective discussion on the topic...
> http://www.15seconds.com/issue/010514.htm
>
> I hate to sit on the fence, but there is a place for
> database solutions like MS Access on the web and i would not
> discourage anyone from investigating their utility.
>
> That's my $0.02AUD on databases - and i hope you don't see
> that as being worth half the value of $0.02US opinion ;)
>
> Regards
> Peter Schonefeld
> Web Developer
> http://digitalcraft.com.au
>
>
>
> > -----Original Message-----
> > From: owner-hwg-techniques(at)hwg.org
> > [mailto:owner-hwg-techniques(at)hwg.org]On Behalf Of
> > Hank Marquardt
> > Sent: Monday, 10 September 2001 9:59 PM
> > To: Peter Schonefeld
> > Cc: Hank Marquardt; hwg-techniques(at)mail.hwg.org
> > Subject: Re: publishing from a database (MS
> > Access Database)
> >
> >
> > OK, I editorialized more than I should have an
> > now I must pay --
> >
> > Access has two problems --
> >
> > First, it has long become much too complex to be
> > a true end user
> > database -- something it was probably good at
> > once upon a time.
> >
> > Second, it's nowhere near robust enough from a
> > speed, scaleablilty,
> > reliability standpoint to do real work even at
> > the workgroup level.
> >
> > So what's left? ... I guess you could prototype in it.
> >
> > ... and since I've shown my bias already, I
> > expect any links I provide
> > would be seen as biased; but go use google and
> > look for "Access vs. Mysql"
> > or "Assess vs. SQL Server" or "Access Data
> > Corruption" or "Access User Load"
> > or even go look at the MS bugs database in the
> > Access section.
> >
> > ... then ask yourself if you can think of a
> > single web site that has both
> > significant traffic (>10000 hits day) AND even
> > 99.9 uptime (remember,
> > clustered dbs of important stuff would be 99.999
> > uptime) that uses Access
> > as a backend ... if you can think of one, let me know:)
> >
> > I think someone else mentioned it being an
> > inexpensive platform -- seems to me
> > there are free alternatives out there; even for
> > windows platforms that
> > perform better ...
> >
> > and so you don't think I'm just an 'open source
> > nut' ... if you want to stay
> > on an MS platform, SQL Server is a perfectly
> > servicable platform, use it and
> > be happy, at least it was designed to be a
> > database and functions accordingly.
> >
> > So none of that helps the original poster solve
> > his problem, but it's my
> > $0.02US on databases.
> >
> > Hank
> >
> > On Mon, Sep 10, 2001 at 02:19:33PM +1000, Peter
> > Schonefeld wrote:
> > >
> > >
> > > > -----Original Message-----
> > > > From: owner-hwg-techniques(at)hwg.org
> > > > [mailto:owner-hwg-techniques(at)hwg.org]On Behalf Of
> > > > Hank Marquardt
> > > > Sent: Monday, 10 September 2001 10:19 AM
> > > > To: Duane Ruth-Heffelbower
> > > > Cc: hwg-techniques(at)mail.hwg.org
> > > <Hank>
> > > > Convert the whole darned ap to a real sql
> > > > database (of which I don't consider
> > > > Access)
> > > </Hank>
> > >
> > > Hmmm, A big punch in the face to MS Access.
> > I'm wondering
> > > what it did to deserve that ;)
> > >
> > > Hank, why don't you consider Access a "real SQL
> > database"?
> > >
> > > Regards
> > > Peter
> > >
> > > -- longest to do, but then updates would
> > > > be real time (or staged with
> > > > permission/publication); whether this is a good
> > > > idea really depends on how
> > > > the workload is spread between web and non-web
> > > > interactions ... though a little
> > > > server box on an intranet bridges the need quite
> > > > nicely as well.
> > > >
> > > > From a dataset size perspective, 400 records in
> > > > nothing and well within what
> > > > even access can handle but if you're going to let
> > > > the world bang on it and look
> > > > at it I think you want something more robust.
> > > >
> > > > HTH
> > > >
> > > > Hank
> > > >
> > > > On Sat, Sep 08, 2001 at 09:36:57PM -0500, Duane
> > > > Ruth-Heffelbower wrote:
> > > > > I do the web work for a non-profit with about
> > > > 400 members who are kept track
> > > > > of in an Access database. The group wants to
> > > > make some of the membership
> > > > > info available on the web, names, areas of
> > > > practice and contact info. I have
> > > > > not done a database to web piece before. What
> > > > would be the best way to
> > > > > handle it, assuming updates a few times a year?
> > > > > __________________________________________________
> > > > > Duane Ruth-Heffelbower, Webmaster
> > > > > www.voma.org, www.vorp.org
> > > > > www.fresno.edu/pacs/
> > www.RestorativeJusticeProject.org
> > > > > www.RJInternational.org
> > > > > www.EmpoweringForReconciliation.org
> > > > > www.ukdw.ac.id/lpip/pspp
> > > > > www.peacemaking.com  www.duanerh.iwarp.com
> > > >
> > > > --
> > > > Hank Marquardt <hank(at)yerpso.net>
> > > > http://web.yerpso.net
> > > >
> > > > Web & Database Development in PHP, MySQL/PostgreSQL
> > > > Small Office Networking Solutions - Debian
> > > > GNU/Linux & FreeBSD
> > > > PHP Instructor - HTML Writers Guild
> > </>
> > > > *** Beginning PHP -- Starts August 20, 2001
> > > > *** /services/classes/p171.3.html
> > > >
> > > >
> >
> > --
> > Hank Marquardt <hank(at)yerpso.net>
> > http://web.yerpso.net
> >
> > Web & Database Development in PHP, MySQL/PostgreSQL
> > Small Office Networking Solutions - Debian
> > GNU/Linux & FreeBSD
> > PHP Instructor - HTML Writers Guild </>
> > *** Beginning PHP -- Starts August 20, 2001
> > *** /services/classes/p171.3.html
> >
>

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA