I have a DVD for my physics class that only can be opened in Windows for whatever reason (I also have a game I want to use). OS X recognizes it, but when I boot into Windows 7 (RTM Build 7600) in VMware Fusion, I see no sign of it.
Make sure that under the sharing properties you have CD/DVD shared.
Then
Open up VMware first. Once it is open make sure to click in it so that you know it is activated.
Put the DVD in the player and close it. You should see it automatically start. If it doesn't double click on the cd/dvd icon.
This has worked for me pretty much every time. The same thing happens when I use my thumbdrives or external hard drives. You just have to make sure they are set to share under the preference settings.