Using ADO Objects

ADO uses objects to access data and provide that to the user. If you are using the Microsoft ADO Data Control, then you don't have to instantiate your connection and recordset objects. However, if you choose to create and dispose of connections and recordsets on-the-fly, you will need to instantiate and later destroy your objects. Furthermore, the current shipping version of the ADO Data Control will use ADO 2.1 functionality (such as Index support) only if you create the recordset through code and set the Recordset property of the ADO Data Control to this recordset in code (this may also involve changing your project references to include ADO 2.1 rather than the default ADO 2.0).

To instantiate an object, use the New keyword. On declaration of the object:

Dim cn as New ADODB.Connection 
Dim rs as New ADODB.Recordset 

Immediately before use:

Dim cn as ADODB.Connection 
Dim rs as ADODB.Recordset 
Set cn = New ADODB.Connection 
Set rs = New ADODB.Connection 

To dispose of those objects:

Set rs = Nothing 
Set cn = Nothing