ADODB is the "Component". A component is a bunch of related classes grouped into a single DLL (dynamic link library) file. When you set a reference to the ADODB component, you have access to all of its classes. The Connection class is one of these. So, your syntax is Dim Conn as ADODB.Connection, or simply Dim Conn as Connection if you don't have any other DLLs that you are using that have a Connection class. The reason we usually specify ADODB is because a lot of the classes have the same names as DAO--an older technology based on ODBC--classes. So, if you can't get a Connection to work, start there.
Once you've taken a crack at getting something to work, post your code and we'll help you fix it if you need us to.
This post has been edited by BobRodes: 18 May 2013 - 10:25 AM