Hi David,
I only have experience with collections management software from a conservation standpoint, all of which have been paid software - TMS, K Emu, and MIMSY. The software was already in place by the time I started working at the different institutions so I unfortunately don't have much to say about the selection process. My only thought and comment would be, if you are going to go with a free software, be sure that its data can be exported in a manner that can be read by other software in the future. We ran into that issue at an institution I used to work for where the conservation database would not talk to collections management database, or that the communication was only one way (CMD to CD). This meant that if we were to try to combine any conservation records into a newly added Conservation Module in the CMD, we would have to upload each report individually to have everything in one place. Having had the CD in operation for over 15 years, that was a lot of paperwork that would need to be manually moved. I would hate for you to go through the process of digitizing and uploading all of the information from your paper files only to have to then manually migrate them later.
I've also worked in institutions where the previous file format is no longer legible by current software or operating systems. A system that has some longevity behind it may be more beneficial in the long run for keeping files accessible.
Do you have Microsoft Access as part of the museum's work suite? I have colleagues who have built databases within it (laboriously, but definitely functional), and if you already have it then it would be a no cost option to get started.
Best,
Liz
------------------------------
Elizabeth Peirce
Connecting to Collections Care Monitor 1/22-2/4
Conservator (Objects)
Library of Congress
Washington DC
------------------------------