[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Automating Vertical File Indexes



Christina, I considered Access, and it looked as though Access would work for
producing the indexes if I did some Visual Basic programming to go with it.
But our Systems people say that Access wouldn't support the online public
usage well. They also advised against doing the indexes in Access and then
translating them into something else for public use (especially since we are
constantly adding to the indexes--it's not like a collection finding aid, that
you seldom alter once it's written). The Systems folks suggested we might want
to look into developing a database using SQL. But I want to be sure there's
nothing out there that would work easily before we start building our own.

"Wolf, Christina" wrote:

> Please respond to the list.  Any takers for Access?  If you do use Access,
> would you be interested in sharing?
>
> Christina Wolf
> Archivist & Special Collections Librarian
> Oklahoma City University
> cwolf@okcu.edu
>
> -----Original Message-----
> From: Nancy L. Hadley [mailto:nlhadl@MAIL.WM.EDU]
> Sent: Wednesday, September 05, 2001 12:58 PM
> To: ARCHIVES@LISTSERV.MUOHIO.EDU
> Subject: Automating Vertical File Indexes
>
> We're looking at computerizing a rather complex card system that
> provides access to our faculty-alumni vertical files; our subject
> vertical files; our campus publications vertical files; university
> archives photographs; and the index to campus newspapers; as well as
> pointers to the finding aids for archival and manuscript collections and
> archives books. None of the archival, library, museum, or indexing
> software we've looked at seems to exactly fit our needs. What I envision
> is a relational database with umpteen tables, all linked through
> authority records for people, offices, and subjects. (Of course it's
> full of many-to-many relationships.) The authority records need to hold
> information as well as names and allow for hierarchies of terms. It
> should be easy for student workers to enter data, and support a nice
> fast public interface over the Web. Has anyone out there tackled this
> type of problem? What worked (or didn't)? Any advice or comment is
> welcome, please! It would be so nice to stop typing all these 3x5
> cards...
>
> --
> Nancy Hadley
> Senior Archivist
> Earl Gregg Swem Library, College of William & Mary
> P.O. Box 8794
> Williamsburg, VA 23187-8794
> (757) 253-4865
> nlhadl@mail.wm.edu
>
> A posting from the Archives & Archivists LISTSERV List!
>
> To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
>       In body of message:  SUB ARCHIVES firstname lastname
>                     *or*:  UNSUB ARCHIVES
> To post a message, send e-mail to archives@listserv.muohio.edu
>
> Or to do *anything* (and enjoy doing it!), use the web interface at
>      http://listserv.muohio.edu/archives/archives.html
>
> Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>

--
Nancy Hadley
Senior Archivist
Earl Gregg Swem Library, College of William & Mary
P.O. Box 8794
Williamsburg, VA 23187-8794
(757) 253-4865
nlhadl@mail.wm.edu

A posting from the Archives & Archivists LISTSERV List!

To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
      In body of message:  SUB ARCHIVES firstname lastname
                    *or*:  UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu

Or to do *anything* (and enjoy doing it!), use the web interface at
     http://listserv.muohio.edu/archives/archives.html

Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>