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.
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.