Fredrik Wahlgren wrote:
I have
multiple versions of Microsoft ActiveX DAta Objects 2.x library
references
available. Should I select all of them also?


No. Select ADO 2.8 which is the latest (and possibly last) version of
ADO.

Again, this will result in a missing reference for users who do not
have ADO 2.8.

The better approach in these circumstances is to use late binding e.g.

Dim cn As Object
Set cn = CreateObject("ADODB.Connection")

The version recordsed against "ADODB.Connection" in the registry will
be used. This will always be the most recent version of MDAC installed
on that machine i.e. will be ADO 2.8 if available.

Jamie.

--