Slet en post i Access Via form
Hej Igenjeg skal kunne slette en post i min db via en form der kalder en asp fil.. her er asp filen :
<html>
<title>Slet Fra DB</title>
<head>
<meta name="Generator" content="Stone's WebWriter 4">
</head>
<body>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=Links.mdb"
Conn.Open DSN
' SQL sletter record
strSQL = "Delete from link Id = Request.Form("idr")"
Conn.Execute(strSQL)
' Luk databaseforbindelse
Conn.Close
Set Conn = Nothing
%>
<div style="text-align:center"><h1>Record er slettet!</h1></div>
</body>
</html>
men den kommer med en fejl her er fejlen :
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/sletlink.asp, line 15
strSQL = "Delete from link Id = Request.Form("idr")"
----------------------------------------------^
