VBA og recordsets....

Dim conn As Database
Dim ws As Workspace
Dim rs As Recordset
Dim fld As Field
Dim sql As String

sql = "SELECT " + columeName + " FROM " + Settings.getPrefix() + tableName

Set ws = DBEngine.CreateWorkspace("myODBCWorkSpace", "", "", dbUseODBC)
Set conn = ws.OpenDatabase("ThisDatabase", False, False, "ODBC;dsn=" + Settings.getAccessDNS) ' Shared, read-only



Jeg får en Type mismatch fejl i denne line:
*Set rs = conn.OpenRecordset(sql)*
Er der nogen der kan se hvad jeg gør forkert?