PDA

View Full Version : ADO Version



Marcster
11-16-2009, 07:52 AM
In the VBE References I check:
Microsoft ActiveX Data Objects 2.6 Library
FileName: msado26.tlb

When I run this macro:


Sub testADO()
Dim cnn1 As ADODB.Connection
Set cnn1 = New ADODB.Connection
MsgBox cnn1.Version
Set cnn1 = Nothing
End Sub


It displays 6.0 ???
I thought I was setting it to version 2.6?

Also how do get the help to work for ADO in the VBE?.
Highlighting a word then pressing F1 just brings up a blank help.

Bob Phillips
11-16-2009, 10:20 AM
Odd, I get 2.8!

You will need tgo goto MSDN to get ADO help.

Marcster
11-16-2009, 11:22 AM
Found ADO help file.
Seems I managed to mess up associations, references or something.
Odd that we both done the same thing by ref 2.6 but getting different versions...