This question comes up from time to time and I always offer my recommendation; I apologize if I sound like a broken record. Try Music Collector from
www.collectorz.com (previously KeepItCompact Music.) I've tried most of the music cataloging software out there and it's the best I've seen. It's also one of the few pieces of shareware I've paid for. I like it that much.
They also have a Movie Collector product that isn't quite as robust but, from talking with the authors, they will be making changes to it, and their entire suite of products, in the near future.