Fejl i sql streng

hvilke kolonnetyper er user_username og user_password?

41:      SQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"   
    Set rs = DataConn.Execute(SQL)
42:      SQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"   
    Set rs = DataConn.Execute(SQL)

eller:

41:      strSQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"   
    Set rs = DataConn.Execute(strSQL)
42:      strSQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"   
    Set rs = DataConn.Execute(strSQL)

Så vidt jeg kan se er din sql sætnings navn ikke det samme som du exekvere....

/Tubber

s

tak for hjælpen...