The version of Microsoft ActiveX Data Objects (ADO), listed in the Applies To section, ships with an ADO 2.0 Type Library file.
The name of the type library file is Msado20.tlb and by default the file is located in the \\Program Files\Common Files\System\ADO subdirectory.
If a project that originally used ADO 2.0 is opened after ADO 2.1 has been installed, you will see that the project references the ADO 2.0 Type Library and not the ADO Dynamic Link Library.
In other words, the project reference still shows "Microsoft ActiveX Data Objects 2.0". However, the file this reference is pointing to will be the ADO 2.0 Type Library, Msado20.tlb, and not the ADO Dynamic Link Library, Msado15.dll.
This behavior differs from prior versions of Microsoft ActiveX Data Objects. Prior versions did not ship with type libraries for previous versions. Therefore, projects created with the earlier versions automatically started using the newer interfaces of Microsoft ActiveX Data Objects installed although the project's references continued to point to the Microsoft ActiveX Data Objects Dynamic Link Library, Msado15.dll.
To switch to the new ADO 2.1 interfaces, clear the project reference for "Microsoft ActiveX Data Objects 2.0", Msado20.tlb. Next, select the reference for "Microsoft ActiveX Data Objects 2.1", Msado15.dll.
For additional information, please see the following article in the Microsoft Knowledge Base:
201580Â
(http://kbalertz.com/Feedback.aspx?kbNumber=201580/EN-US/
)
INFO: ADO 2.0 and ADO 2.1 Binary Compatibility