The problem with access is that it does not have the ability to handle
multiple simultaneous users. I believe it can only handle 20 at a time. In a
typical web page I could use the database as many as 4-5 times, then you'd
be down to 4-5 simultaneous visitors, any more would crash your database and
possibly corrupt your data. Also there's the problem with the escape
character, M$ in their infinite wisdom decided to use ' as the escape
character instead of \ like every other database in the world.

Data Driven Design
1506 Tuscaloosa Ave
Holly Hill, Florida 32117

http://www.datadrivendesign.com
Phone: (386) 226-8979

Websites That WORK For You
----- Original Message -----
From: "Klaas De Waele" <klaas(at)gracegraphics.be>
To: <peter.schonefeld(at)bigpond.com>; "'Hank Marquardt'" <hmarq(at)yerpso.net>
Cc: <hwg-techniques(at)mail.hwg.org>
Sent: Monday, September 10, 2001 3:26 AM
Subject: RE: publishing from a database (MS Access Database)


> Would like an explanation of this too.  After all, mdb files are
databases.
> And Access is merely a tool to approach them.  It's the database that runs
> on the server, not Access.  So okay, Access isn't the most wonderful or
> powerful database access tool.  I mean... I know notepad doesn't have all
> the functions of word and has rendering problems, but I still consider
> notepad as a very healthy and helpful tool - wouldn't want to live
without.
>
> Access databases are the ideal solution for low-cost database server
> deployment (or whatever you'd call it) and offer a great platform to learn
> working with SQL (even if it's just JetSQL).
>
>
> - Kayjey -
>
>
>
> > > -----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
> > >
> > >
> >
> >
> >
>

• Web Designer Courses
• Off the Shelf Training Courses

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