Syntax error (missing operator) in query expression

Hej eksperter

Er der nogen, der kan gennemskue, hvad der går galt her?

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tbl_equiv.usexFROM tbl_lemmaINNER JOIN tbl_equiv ON tbl_lemma.id_lemma = tbl_equiv.fr_lemma WHERE tbl_lemma.lemma LIKE '%%' OR tbl_equiv.equiv LIKE '%%' OR tbl_equiv.dkex LIKE '%%' OR tbl_equiv.usex LIKE '%%'ORDER BY LCase(tbl_lemma.lemma)'.

/searchresults.asp, line 170

og linje 170 er:

Set rs = myConn.Execute(strSQL)

Jeg har kontrolleret for syntaksfejl og reserverede navne + kontrolleret alt (mener jeg….)

SQL-sætning etc. ser således ud:

<%
Dim myConn
Dim DSN
Dim searchText

set myConn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("test.mdb")
myConn.Open DSN

searchText = replace(request.form("text"),"'","''")
if searchText = "" then
  searchText = replace(request.querystring("search"),"'","''")
end if

'SQL-sætning henter data

strSQL = "SELECT tbl_lemma.id_lemma" & _
", tbl_lemma.lemma" & _
", tbl_equiv.id_equiv" & _
", tbl_equiv.equiv" & _
", tbl_equiv.dkex" & _
", tbl_equiv.usex" & _
"FROM tbl_lemma" & _
"INNER JOIN tbl_equiv ON tbl_lemma.id_lemma = tbl_equiv.fr_lemma" & _
"WHERE " & _
" tbl_lemma.lemma LIKE '%" & searchText & "%'" & _
" OR tbl_equiv.equiv LIKE '%" & searchText & "%'" & _
" OR tbl_equiv.dkex LIKE '%" & searchText & "%'" & _
" OR tbl_equiv.usex LIKE '%" & searchText & "%'" & _
"ORDER BY LCase(tbl_lemma.lemma) "

Set rs = myConn.Execute(strSQL)

%>

Any ideas?

hwks