Missing operator in query expression 'id ='

[wegawhite]

Cosa c'è di sbagliato in questo code:

Username = session("username")
response.write username &"
"
id = session("id")
response.write id &"
"

Dim Conn, SQL, Rec
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="& server.MapPath("/mdb-database/Whole.mdb")

SQL = "SELECT * FROM users where id = " &id
response.write sql &"
"
Set rec = Server.CreateObject("ADODB.Recordset")
Set Rec=Conn.Execute(SQL)

perchè restituisce:

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

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id ='.