NickHK wrote:

You can certainly:
Set obj1 = CreateObject("ADODB.Recordset.2.5")
Set obj2 = CreateObject("ADODB.Recordset.2.7")

For the recordset object, I have three registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ADODB.Recordse t
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ADODB.Recordse t.2.8
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\ADODB.Recordse t.2.7

However, they all share the same CLSID, so it doesn't matter which name
I use in CreateObject, I'll always get an object from the same
component.

My machine also has version ADO 2.6 available as a reference, but when
I try

Set obj1 = CreateObject("ADODB.Recordset.2.6")

I get the expected error, 'ActiveX component can't create object'.
Jamie.

--