Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error message Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

Status
Not open for further replies.

makumbi

Programmer
Mar 15, 2011
12
UG
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 -->
--------------------------------------------------------------------------------
 
The default cursor type and location means the recordset is readonly
faq333-618

Use a clientside cursor (adUseClient) objRS.CursorLocation

And a Dynamic or Keyset type objRS.CursorType

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top