[WEB4LIB] Re: MS-Access database - for archives

[M.T.Davis]

I'm currently using Access 2000 to create a lexical archive, much like a
dictionary of sorts. I am using the Developer's Edition of Office 2000 which
I chose because I am able to create a standalone Access application that
users can install on their windows machines without having the Access
application. According to the documentation it is scalable (in a sense) by
using the "upsizing wizard" which converts an Access database (.mdb) to a
client/server application. It promises to create an equivalent database on
SQL server while maintaining all the objects in the original database. I
haven't got to this point yet (I am in library school and this is an
independent study project), but if I get there, I'll post some results.

M.Troy Davis
   Graduate Assistant
   Department of Library and Information Studies
   The University of North Carolina at Greensboro
   349 Curry Building, Greensboro, NC 27402
   (336) 334-5101      mtdavis at uncg.edu




----- Original Message -----
From: Raymond Wood <raywood at magma.ca>
To: Multiple recipients of list <web4lib at webjunction.org>
Sent: Thursday, August 23, 2001 6:43 PM
Subject: [WEB4LIB] Re: MS-Access database - for archives


> On Thu, Aug 23, 2001 at 09:47:20AM -0700, Karen Harker imagined:
> > I've been trying to find the same thing out.  I did create one, but it
> > seemed so complex that I was worried about its scalability...would it
> > break-down under heavy load?
>
> All anecdotal evidence I've ever encountered from other web developers
> suggests that Access simply does not scale.  This begs the question at
> what point does it begin to fail?  This I do not know from personal
> experience, but this article may shed further light on this point:
>   http://linuxtoday.com/news_story.php3?ltsn=2001-07-27-006-20-RV-SW
>
> Raymond
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> That's not gibberish...  It's Linux. - Byers, The Lone Gunmen
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=