Except the baseball cards.
I keep my baseball cards in Rubbermaid containers, originally to prevent bugs, coons, possums and other vermin from nesting in there. None of them had water damage except one... Only one container was damaged, and some water leaked in. A few football and hockey, and part of a '76 Topps baseball set were ruined, but in reality, I was pretty lucky.
At the time, I realized how really sad I would have been if all those baseball cards I'd been collecting over the course of my life had been destroyed. It was not the money value of these cards, it was my emotional connection with them. I decided I'd try to insure them, and was happy to find out that my homeowner's policy would cover them, though I needed to be able to provide precise list of all the cards.
I searched and searched for any software that could do what I wanted to do, and could not find anything useful. I knew I would have to write my own. I decided I'd use Microsoft Access as it is very easy to use, has forms for the UI and a capable report writer, if I wanted one. While I was a programmer at one point in my career, I really didn't want the project to be "work".
The top left is where you select a set to work with, after selecting the set, the lower left fills with each card in the set. If you click a card in the, the image of it loads as does the inventory for that card. If I wanted to add a card to inventory, I double-click the card list in lower left. Pretty straightforward.
It isn't pretty, but it does everything I need it to do, and I don't really have anyone to please but myself! Before you ask, no, I didn't type every single card in by myself. Some wonderful person behind Trading Card Database has done the work for me. I just copy his lists, paste to text file, import the text in to Excel, manipulate the rows as I need adding set ID numbers, sub set ID numbers, display order, etc, then I copy all those rows right in to the database table. I'm mostly finished adding in the set definitions, but a long long way from entering my inventory of cards in to the tables. But it's a labor of love, and it can be very relaxing. So, really, I do not mind.
I gave each card record a link to an image file, should I be crazy enough to want to actually scan every card I own some day. Very doubtful... Also, the database is linked with Sean Lahman's database, so should I get free time some day, I can link each card's represented player to his stats, personal data and so on. If you're not familiar with Lahman's, it's essentially the backend to the baseball-reference website. For now, though, it's a work in process, a pasttime that combines my love of cards with my love of programming.
I was curious how do all of you keep track of your collections?