Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
/catalogue/asp_access_delete_checkbox2.asp, line
but before i tried to debug the out put was
DELETE FROM customer1 WHERE CustomerID = 5
please help me find the problem
<% Option Explicit %>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<%
Dim Conn,strSQL,objExec,chkDel
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= C:\Inetpub\
strSQL = ""
For Each chkDel in Request.Form("chkDel")
strSQL = "DELETE FROM customer1 WHERE CustomerID = " & chkDel
Response.write(strSQL)
Response.end()
'Set objExec = Conn.Execute(strSQL)
Next
Response.write("Record deleted.")
Conn.Close()
'Set objExec = Nothing
Set Conn = Nothing
%>
</body>
</html>
<!--- This file download from -->
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
/catalogue/asp_access_delete_checkbox2.asp, line
but before i tried to debug the out put was
DELETE FROM customer1 WHERE CustomerID = 5
please help me find the problem
<% Option Explicit %>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<%
Dim Conn,strSQL,objExec,chkDel
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= C:\Inetpub\
strSQL = ""
For Each chkDel in Request.Form("chkDel")
strSQL = "DELETE FROM customer1 WHERE CustomerID = " & chkDel
Response.write(strSQL)
Response.end()
'Set objExec = Conn.Execute(strSQL)
Next
Response.write("Record deleted.")
Conn.Close()
'Set objExec = Nothing
Set Conn = Nothing
%>
</body>
</html>
<!--- This file download from -->
--------------------------------------------------------------------------------