en access database fejl i asp
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID=Sanaa Lathan'.
/filmzonen/default.asp, line 820
er der nogen der kan være behjælpelig med hvorfor jeg ikke kan få det til at fungere..
-------------------------------
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("db.mdb")
id = Request.QueryString("id")
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM actor WHERE ID=" & id, Conn, 1, 3
rs("hits") = rs("hits") + 1
rs.Update
%>
<table border="0" width="400" cellspacing="0" cellpadding="3" height="400" id="table5" background="images/midtbandmeldelseranm.jpg">
<tr>
<td height="55" colspan="2">
</td>
</tr>
<tr>
<td width="250" valign="top" height="210"><br><b>
<% If rs("Id") & "" = "" then %>
<% response.write("Ikke indtastet! ") %>
<% Else %>
<% = rs("Id") %>
<% end if %></b><br>
</td>
<td width="138" valign="top" rowspan="2">
</td>
</tr>
<tr>
<td width="250" valign="top">
</td>
</tr>
<tr>
<td height="28" colspan="2">
<a href="java script:history.go(-1)">
<img border="0" src="images/tilbage.jpg" width="83" height="15" align="right"></a></td>
</tr>
</table>
