Compile Error

[Meltdown]

Hi all, I keep getting a Compile Error when I try to run some code, it a "Error Loading dll" error.

Below is a snippet of code, it stops at Set conn = CurrentProject.Connection

 Dim conn As New ADODB.Connection
        Dim rs As New ADODB.Recordset
        
        Set conn = CurrentProject.Connection

I have no missing references.
I have compacted and repaired

I have the reference to ADO 2.6 as the top in my list of references.

Hope someone can help, I didn't find a solution that worked with the search results I reviewed.

Thanks