Yeah sorry should have looked at the error msg. closer ccleaner will not fix this issue (although it is still a good program

)
According to MS these are the causes
This issue may occur if one of the following conditions are true:
•There is a configuration issue with the CD-ROM drive.
•The MDAC (Microsoft Data Access Components) is damaged or is not installed properly.
•There is an issue with the CD-ROM media. For example, the program CD-ROM is damaged or dirty.
http://support.microsoft.com/?kbid=248263
This may also help you
http://help.lockergnome.com/general/...pict41550.html
Even more help
http://www.call-of-duty.co.uk/viewto...406fe83f8491ba