Don’t give up! Microsoft Cinemania is a great piece of software, and should work under Windows 7. I have Windows 7 64-bit and use Cinemania ’97 all the time without any problems.
I recommend copying the program to your hard disk before installing it (that’s what I did, that way you don’t have to go and get the CD-ROM every time you want to use it). To do this create a folder in your shared documents folder (C:\Users\Public\Documents) called ‘Cinemania 96’. Copy everything on the Cinemania CD to this folder and then run the installation file from there.
Otherwise, you could try running the program in compatibility mode, or using a virtual PC (such as the windows 7 windows XP mode or the free program VirtualBox).
What happens when you try to install Cinemania? Do you get any error messages? Let us know, if you provide more details we might be able to help you.