I've used several different programs over the years. I started with an Access database I built myself. I eventually imported that in to Spinfree Audiofile v. 4.03. Spinfree hasn't supported the product actively in a couple of years, so when Windows XP came out, using the Audiofile Internet Companion to retrieve CD info automatically became problematic. Just recently, I ported everything over to Collectorz Music Collector v. 6.1. (http://www.collectorz.com/music/)
I have been very happy with Music Collector so far. It can be relatively complicated to use if you want to delve into the more esoteric and detailed information fields, but, if you are inclined you can store everything from the basic info like title and track names to musicians, producers and engineers, where and when you bought it, the record label, etc. It's extremely detailed and easy to search. It also has an excellent lookup utility, where using either the basic disc data (retrieved from this disk automatically be inserting it in a drive), the UPS code (eithertyped in or scanned, if you have a bar code scanner), or the artist and title, it will query not only the CDDB, like most other music cataloging programs, but also the All Music Guide and Amazon.com info. Check out the website. I've been very happy with it's ability to keep track of my 1500+ CD, 2000+ CD-R, 500+ DAT collection