Update Problem
Hejjeg fået følgende problem:
Min: default.asp
<html>
<head>
<title>Opdater tricks</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" link="#666666" vlink="#666666" alink="#666666">
<table width="545" border="0" align="center" height="209" cellpadding="0" cellspacing="0">
<tr bgcolor="#666666">
<td width="61%" height="62">
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="6">Admin>tricks.asp</font></div>
</td>
</tr>
<tr>
<td width="61%" height="491">
<div align="center">
<table width="471" border="0" cellspacing="0" cellpadding="0" height="276">
<tr bgcolor="#000000" valign="top" align="center">
<td width="471" height="63">
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="7" color="#FFFFFF">HTML</font></div>
</td>
</tr>
<tr valign="top" align="center">
<td width="471" height="397">
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("\log\opdatering.mdb")
SQL="SELECT * FROM tricks"
Set RS = Conn.Execute(SQL)
%>
<form method="post" action="hub.asp?id=1">
<textarea name="kode" rows="20" cols="80"><%=RS("kode")%></textarea>
<br><br>
<input type="submit" name="Submit" value="Opdater">
<br><br>
</form>
<%
RS.Close
Conn.Close
Set Conn = Nothing
%> </td>
</tr>
</table>
</div>
</td>
</tr>
<tr bgcolor="#666666">
<td width="61%" height="73">
<div align="center"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">Er
du i tvivl om hvordan du opdaterer kontakt da <font color="#999999">webmasteren</font><br>
</font> </div>
</td>
</tr>
</table>
</body>
</html>
Min hub.asp
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("\log\opdatering.mdb")
SQL="UPDATE tricks SET kode='"&request.form("kode")&"' WHERE tricks.ID="&request("id")&""
Conn.Execute(SQL)
Response.Redirect("default.asp")
%>
Min database
ID
kode
Probelmet kommer her:
Microsoft OLE DB Provider for ODBC Drivers fejl '80004005'
[Microsoft][ODBC Microsoft Access-driver] Søgenøglen blev ikke fundet i nogen poster.
/admin/tricks/html/hub.asp, linje 5
Håber at i kan finde fejlen
