MISSING: Microsoft ActiveX Data Objects 6.0 Library

[MikeDBMan]

If I look in the VBA Editor and select Tools>References, I see the above line checked in my listing. I tried to get it to be found by adding this code at the time of opening:

Application.VBE.ActiveVBProject.References.AddFromFile "c:\Program Files\Common Files\System\ado\msado15.dll"

But I still have the "MISSING" message. Suggestions? The User is running Windows 7 and Excel 2010. Thanks so much.
I also added the network path where the file is located as a trusted site and checked the checkbox: Trust access to the VBA PRoject object model" checkbox in the Trust Center Settings.
I don't know what else to do.

 

[Derek Brown]

In case this helps others ...
Excel workbook code that has run without any problem each month this year, today crashed without any error message (just the 'Stopped working' useless message).
Even trying to compile the code caused Excel to crash - that is a very worrying thing to happen!
As per the last post, the solution was to deselect the (now missing) Microsoft ActiveX Data Objects 6.0 Library and then select the 6.1 version. It was also interesting that the 6.1 Library did not appear in the list until I had deselcted the 6.0 Libary!