Legacy system to manage print and electronic journals? Marshall, Susan 15 Oct 2003 23:07 UTC

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