Filing Sheet Music

Gilsondg · Joined: 09 Oct 2004 Posts: 3 Location: Gibraltar

Does anyone know of a good databse for keeping track of Organ Music. I have loads of sheet Laughing

music and albums which I need to catalogue.
Have tried to write one under MS access, with limited success.

lancecornea · Posted: Mon Apr 10, 2006 1:21 pm Post subject:

You might find something here which can be adapted for your needs
eg. Book Collector
http://www.collectorz.com/

Good Luck

Lance

diapason8 · Joined: 31 Mar 2006 Posts: 365 Location: West Somerset, UK

I've got a simple database which a local programmer wrote for me a while back. It runs in MS Access and has fields for name, composer, parts, season etc. I used it and it worked well for me. Unfortunately, I lost all my data earlier this year when my old hard drive -and the backup -were virus-damaged. I have to start again, but am holding fire as I'm considering a move to another church. I have still got the basic program and will try to email it if it sounds useful.

Regards,

Nigel

PS -I hope the music of Lord's Prayer arrives safely through snail-mail.

Jason Evans · Joined: 27 Feb 2006 Posts: 535

MS Access is a good program, once you grasp the concept of a "relational database". I've used it for years to catalogue my extensive CD collection. I imagine it would be superb for sheet music.

lancecornea · Posted: Wed Apr 12, 2006 4:30 am Post subject:

If you just want a simple database (spreadsheet type) then MS Excel is as good as any. I have three extensive databases in this format, my CD's, my vinyl recordings, and my Psalms of David to Anglican Chant (recorded versions) They work really well for me and I have been doing it this way now for over 15 years. If I was looking to catalogue my anthems and sheet music I'd more than likely stick with this system

My two penneth!

Lance

Jason Evans · Joined: 27 Feb 2006 Posts: 535

True, Excel will work for most situations. Access is good for very large collections. You could have a separate table for, say composers or publishers. It makes updating easier. BTW, I assume you have the 10 volume set on Priory of the Psalms of David?

lancecornea · Posted: Thu Apr 13, 2006 5:35 am Post subject:

Yes Jason, I do and also the complete set by St.Paul's / John Scott. All up I have 521 psalms to listen to sung in Anglican chant, a few of which are even sung in Swedish !!
So I need to keep them on a database to track down the chants and choirs I want.

Lance

Jason Evans · Joined: 27 Feb 2006 Posts: 535

lancecornea · Posted: Thu Apr 13, 2006 6:20 am Post subject:

I am listening to Psalm 7 to Barnby and Garrett as I type and it certainly makes a fine coupling.
To answer your query on the Anglican Chant Book, I will need a couple of days to think about it. I have a busy Good Friday with 2 performances of Crucifixion tomorrow, which will cosume my time.
With regard to the St.Paul's set, they use their own Psalter which I would recommend you buy as it is edited and pointed by John Scott. You can then (except in a couple of Psalms) follow the whole 150 plus the Easter Anthem as you purchase the discs.
Do you have the 2 volume selection by Westminster Abbey and the 3 volumes by King's?

Happy Psalming!

Lance

Jason Evans · Joined: 27 Feb 2006 Posts: 535

lancecornea · Posted: Thu Apr 13, 2006 9:09 am Post subject:

King's are re-releases on EMI from the original vinyl recordings which you may already have. My copies of Westminster Abbey are on Virgin Classics. Vol 1 is from 1991 and Vol 2 from 1995. I'm sure they are all still available.
A friend of mine got me the St. Paul's Psalter from the cathedral, as it is their own publication. It is printed by The Lavenham Press Limited, Lavenham, Sudbury, Suffolk, and is distributed by The Canterbury Press Norwich. Try the Cathedral Gift Shop at St.Paul's

Lance

lancecornea · Posted: Thu Apr 13, 2006 9:18 am Post subject:

Hi Jason

Living as I do in an Antipodean outpost called Melbourne (Remember....We had the Commonwealth Games...), there is not such a lot of English Church Music available in the music shops. I use the internet regularly to order from UK and USA as I read CD reviews in the Choral / Organ journals to which I subscribe.
The Westminster Abbey CD's if you want them are available from Amazon UK at this link
http://www.amazon.co.uk/exec/obidos/ASIN/B0007DHQ4I/qid=1144919466/sr=2-3/ref=sr_2_11_3/203-5360054-9951157
Looks like they've issued this now as a 2 CD set at a good price!

Enjoy!!!!

Lance

lancecornea · Posted: Sun Apr 16, 2006 11:35 am Post subject:

Hello again Jason

I trust your Easter celebrations were full of wonderful music!

I have had a bit of a look at Vol 1 of the Priory series of Psalms and you will find all but six of the chants contained in The RSCM Chant Book. This is an excellent publication from The Royal School of Church Music. in the time of Lionel Dakers. It may still be available, but I have had mine for many years. Only the Garrett chant is exclusive to the Anglican Chant Book. Five of the chants I could not locate, but I would suggest they may have been written by past musicians of Hereford Cathedral, and perhaps unpublished.
I tend to think that maybe the Anglican Chant Book has become a bit of a dinosaur, with the RSCM now providing a more suitable alternative for use with the modern language services.

Lance

eagles · Posted: Wed May 24, 2006 11:10 pm Post subject:

If I may sympathise over the virus thing, while there would be little possible to recover I imagine, it isn't a very well known fact that a number of Windows applications will run in a "layer" referred to as WINE in the Linux and Unix computer operating systems... meaning that there is minimal likelihood for viral infections.

I have succesfully installed and used the genuine Microsoft freely-available free-of-gelt "readers" (Word, Excel, PowerPoint) in a number of Linux installations for checking the equivalents produced in the other major office suite - Open Office.

Just a thought in passing.

By the way, WINE is an acronym which stands for Wine Is Not an Emulator.

There is a commercial (you pay real money for it) version of WINE called Crossover Office which may also run Access; I'm pretty sure the basic WINE doesn't.

Virii are indeed a scourge. So also is deleting all files when you think you have made a backup, and haven't. Argh.........
_________________
Have you noticed editing is always needed for the inevitable typos that weren't there when you hit the " post " button?

Linux User 416434