ADO - SQL Connection In Access

[Paladine]

Hey folks, hope someone can help. I am not a novice to Access, but to ADO use I am. Just learning infact. I am trying to connect to an SQL database. The problem is this; In the attempt to run my connection code I get Runtime Error 426, ActiveX object can not be created and the following line looks like this that is highlighted.

Set adoConn = New ADODB.Connection

The code starts like this (in a sub)
Private Sub ADOConnect()

Dim strConnect As String
Dim adoConn As ADODB.Connection
Dim adoError As ADODB.Error
Dim adoErrors As ADODB.Errors
Dim strADOError As String

Then the line in question. MS ADO Library 2.5 is referenced.

Thanks

Troy

 

[shaddow]

Try to use
Dim adoConn As New ADODB.Connection ________
George, M