Looking for some help with my BF1942 copy.

Ordered this game in CD version off Amazon, had great reviews, everyone seems to be able to run it fine. My boyfriend desperately wanted this game, and figured it would have NO problem running on my Win7 alienware. But, we installed it, tried every compatibility mode possible, and it won't run at all.

So, I'm asking for advice on what to do or if someone has a copy I can have. I appreciate the help.