Access 2010 compile error User-defined type not defined

Question

I converted a 2003 database to 2010 and VBA scripting created in 2003 is not working in 2010. I am getting the message that there is a Complie Error - User-defined type not defined. I do not have experience with VBA scripting and I did not create the script but understand that action that it is completing within the database. The specific item it highlights is the DIM adoConn As New ADODB.Connection.

I am including the script any assistance will be beneficial as the action that is performed is a great asset to our workflow.

Private Sub Error_code_exit(Cancel As Integer)

    On Error GoTo Error_code_exit

    Dim strSQLErrorCode As String
    Dim adoConn As New ADODB.Connection
    Dim adoRSErrorCode As New ADODB.Recordset

    Set adoConn = CurrentProject.Connection

    strSQLErrorCode = "SELECT [Error Matrix1].[Error Code], [Error Matrix1].CTC FROM [Error Matrix1];"

    adoRSErrorCode.Open strSQLErrorCode, adoConn, adOpenKeyset, adLockOptimistic

    If Not adoRSErrorCode.EOF Then

        Do

            If adoRSErrorCode.Fields("Error Code") = Me.Error_Code.Value Then
                If IsNull(adoRSErrorCode.Fields("CTC")) Then
                    Me.chkAgree = True
                    Exit Do
                End If
            End If

            adoRSErrorCode.MoveNext

        Loop Until adoRSErrorCode.EOF

    End If

    adoRSErrorCode.Close
    adoConn.Close

Exit_code_exit:
    Exit Sub

Error_code_exit:

    MsgBox Err.Description
    Resume Exit_code_exit


End Sub

Possible duplicate of ['User Defined Type Not Defined' error](http://stackoverflow.com/questions/24261557/user-defined-type-not-defined-error) — Zev Spitz, Dec 29 '16 at 08:37
Possible duplicate of [Compiler Error: User-defined types not defined](https://stackoverflow.com/questions/5349580/compiler-error-user-defined-types-not-defined) — niton, Oct 31 '17 at 10:10

score 5 · Answer 1 · answered Aug 09 '12 at 18:41

You need to set a reference to the ADODB library. It is :

Microsoft ActiveX Data Objects x.x Library

In the code window, choose Tools->References and scroll down to the reference you need, then tick it. You may have another problem with your code if you use DAO recordsets and they are not explicitly defined as DAO.Recordset

Access 2010 compile error User-defined type not defined

1 Answers1

Linked