Fejl i upload til db
Hejdenne admin/mailingliste er hentet fra netcoders. Jeg får følgende fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/version1/mailing/mailingliste.asp, line 18
---------------------------------------
<%
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "DBQ="&(Server.MapPath(".")) &"\mailing.mdb; DefaultDir=DBQ="&(Server.MapPath(".")) &"\;Driver={Microsoft Access Driver (*.mdb)};"
if request("password") = "test" then
session("login") = "ok"
end if %>
<HTML>
<HEAD>
<TITLE>Mailingliste</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000">
<%
if request("mode") = "1" then
SQL = "INSERT INTO mailingliste ( navn, email ) values ('" & request("navn") & "', '" & request("email") & "')"
'response.write (SQL)
conn.execute (SQL)
response.write "<BR><FONT FACE='Arial' SIZE='3' COLOR='#000000'><STRONG><CENTER>Du er nu blevet tilmeldt mailinglisten.</CENTER></STRONG></FONT>"
else
%>
<CENTER>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2">
<TR>
<TD COLSPAN="2" ALIGN="CENTER">
<FONT FACE="Arial" SIZE="2" COLOR="#000000">
<STRONG>Tilmeld dig Mailinglisten</STRONG>
</FONT>
</TD>
</TR>
<form action="mailingliste.asp" METHOD="POST">
<input type="hidden" name="mode" VALUE="1"><br>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Navn:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="navn" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
E-mail:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="email" size="40"><br>
</TD>
</TR>
<TR>
<TD VALIGN="TOP">
</TD>
<TD ALIGN="RIGHT">
<input type="submit" value="-- Tilmeld --">
</TD>
</TR>
</form>
</TABLE>
<FORM NAME="login" METHOD="post">
<INPUT TYPE="password" NAME="password">
<input type="submit" value="-- Login --">
</FORM>
<% end if
if session("login") = "ok" then
if request("mode") = "slet" then
SQL = "DELETE FROM mailingliste where id ="& request("id")
conn.execute (SQL)
end if %>
<TABLE>
<TR>
<TD>
</TD>
<TD>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
<STRONG>
Navn
</STRONG>
</FONT>
</TD>
<TD>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
<STRONG>
</STRONG>
</FONT>
</TD>
</TR>
<%
SQL = "SELECT * from mailingliste"
set slet = conn.execute( SQL )
do while not slet.eof
on error resume next %>
<TR>
<TD>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
<A HREF="mailingliste.asp?id=<% = slet("id")%>&mode=slet">Slet</A>
</font></TD>
<TD>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
<% = slet("navn") %>
</FONT>
</TD>
<TD>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
<% = slet("email") %>
</FONT>
</TD>
</TR>
<%
slet.movenext
loop %>
</TABLE>
<% conn.close
end if
%>
</center></BODY></HTML>
---------------------------------------
JEG kan heller ikke slette fra db:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
/version1/mailing/mailingliste.asp, line 76
