Syntax error (missing operator)

[Hao]

Salve qualcuno sa dirmi perchè mi da errore?

---------------------------------------------------

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'email=info@cyberwan.ch'.

/ativation.asp, line 13

----------------------------------------------------

strRic = request("@")

dbfile = Server.MapPath("../database/fitbase.mdb")
Set Con = Server.CreateObject( "ADODB.Connection" )
con.connectionstring="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & dbfile & ";"
Con.Open

Set objrs = CreateObject("ADODB.Recordset")
Set objrs.ActiveConnection = Con
objrs.LockType = 2
objrs.open "SELECT * FROM User WHERE email=" & strRic <---------------- errore

objRS("abilitato") = Request("check")
objRS.Update
objRS.Close

Set objRS = Nothing
con.Close
Set con = Nothing

[Roby_72]

objrs.open "SELECT * FROM User WHERE email='" & strRic &"'"

Roby

[Hao]

sisi scusatemi avevo gia chiesto questo errore chiedo perdono eheheh

grazie roby