We did something like this when I was at Rockhurst University, but we did use MS Access.  We did the web scripting using ASP.  It worked out pretty well for us.

Buddy Pennington
Serials Acquisitions Librarian
Miller Nichols Library
University of Missouri - Kansas City
800 E. 51st Street
Kansas City, MO  64110
816-235-1548
816-333-5584 (fax)
penningtonb@umkc.edu

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@LIST.UVM.EDU]On Behalf Of Marshall, Susan
Sent: Wednesday, October 15, 2003 6:07 PM
To: SERIALST@LIST.UVM.EDU
Subject: Legacy system to manage print and electronic journals?

Has anyone developed a legacy system to keep track of your print and
electronic journal packages and individual subscriptions?
I am looking at creating a relational database with MySQL with a web
interface.  Has anyone done something like this?

Currently, we have a huge Excel spreadsheet with the info on it but it is
very inflexible as far as reporting goes.
Also, I am not interested in using Microsoft Access.
 Any other ideas?

(We are current satisfied Serials Solutions users and will keep them but
that system is limited as far as manipulating data and reporting goes.)
(Also, I am not happy with our subscription agent who is currently
"managing" our subscriptions. I think we could save a lot of money by
keeping track on our own.....)

Sue Marshall
Electronic Resources Librarian
Montana State University
Bozeman, MT 59715
(406) 994-4313
smarshall@montana.edu