Advertise on ChoralNet 
ChoralNet logo
The mission of the ACDA is to inspire excellence in choral music through education, performance, composition, and advocacy.

Choral Library Software Help

Hello:
 
I currently use Microsoft Access to manage my choral library (at a university).  I would like to find a web-based program out there that could allow us to upload our library into "the cloud", if you will.  This way, my librarians and I can each have access to it from any computer...can immediately see when something is updated, added, checked out, etc.
 
My band director/chair wants us to use Charms, which he already subscribes to.  I don't see Charms working for us, but I could be wrong.  I've looked at their website, but don't see it being very good for choral libraries.
 
Any thoughts, advice?
 
Many thanks.
 
Erin, UAH
Replies (4): Threaded | Chronological
on January 27, 2014 7:28pm
A good place to start would be with this message from a previous question on a similar topic. It also contains links to other ChoralNet discussions about library software and links to resources already on the ChoralNet website. I'll be curious to hear what folks have to say about the "cloud" aspect of your query. One of my choruses has a web-based database for its library, but it was custom-designed by one of our singers just for us. I know there are some commercial options available, but knowing what works for others is always a good place to begin. Good luck!
 
Frank
on January 28, 2014 5:37am
If it is already in Access, then just use dropbox. If everyone using it has access then they should be able to use and modify (if that is what you want) the data. That will save you a LOT of time in transferring the data.
on January 28, 2014 7:34am
There is at least two ways for you to work:
 
1) You could use the software from Box.com or Dropbox.com and share the file/databased (and the folder) with specific persons. That means that there would still be only one file shared between users. The only problem with that solution is that the database might not be always synchronized between users, but that would be a matter of seconds or minutes in the worst case scenario.
 
2) A more technical answer to that problem would be to have a specialist (or maybe you could find online articles explaining how to do it!) split your database: on one side, you would have all your DATA (that would need to be on a single server [accessible by every user], or Box or Dropbox) and on the other side the application itself. The app on EACH personal computer would access the single database.
 
I don't think you need a web-based software to do what you want... And since you already have the application working, I would personnaly go with the solution #1... Might be a little slower, but MUCH easier and COSTLESS! The second solution needs to take care of updates on each computer and it is a business way to do it...
 
BTW, don't forget to compact your Access database once in a while to have a more efficient app!
 
For more information, don't hesitate to contact me!
 
Guillaume St-Gelais, M.Mus, B.Sc
on January 29, 2014 5:54am
Erin,
 
As long as all users have Microsoft Access on their computers, then all you need to do is move the database file (*.mdb) to the "cloud" (e.g., Dropbox, etc.).
  • You must log in or register to be able to reply to this message.