Referencing the ADO Libraries

As with any library that provides a type library, you must set a reference to the ADO library you want to use in your Visual Basic project. The type library for the current version of ADO is contained within the ADO DLL, msado15.dll. (To meet the needs of certain applications written with older versions, older versions of the type library can be referenced as well through the provided msado20.tlb, msado21.tlb, and msado25.tlb files.)

To reference the ADO library in your Visual Basic project, open the Project menu and click References. Scroll down and select Microsoft ActiveX Data Objects 2.7 Library. If an application compiled on a system with ADO 2.7 must run on a computer with a previous version of ADO installed, it needs to use one of the backwards compatibility type libraries. Add a reference to the appropriate .tlb file instead of to msado15.dll.