>I have no consistency in instantaiting objects, but maybe I should. Are there any advantages to using either of these:
>
>Dim oConn As Connection, oRS As Recordset
>or
>Dim oConn As ADODB.Connection, oRS As ADODB.Recordset
>

It only hurts if you need to reference the DAO object model since it has a recordset object too. In which case VB will use the one that is listed first on the references and you would have trouble identifying the problem.

>And
>
>Dim oBizObj As New myClass
>or

uses late binding.

>Dim oBizObj As myClass
>Set oBizObj = New myClass

uses early binding.