In the VBE References I check:
Microsoft ActiveX Data Objects 2.6 Library
FileName: msado26.tlb
When I run this macro:
[VBA]
Sub testADO()
Dim cnn1 As ADODB.Connection
Set cnn1 = New ADODB.Connection
MsgBox cnn1.Version
Set cnn1 = Nothing
End Sub
[/VBA]
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.
Odd, I get 2.8!
You will need tgo goto MSDN to get ADO help.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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...
Posting Permissions
Reply With Quote
