I am getting the following message:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
/admin_delrecord_saved.asp, line 22
My code is as follows:
<%
delid = Request.Form("delid");
conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("db/products.mdb"))
deleterec = "DELETE tblProducts.ProductID FROM tblProducts WHERE (((tblProducts.ProductID)="+delid+"))";
conn.execute(deleterec);
conn.close;
%>
Any ideas??!
Cheers!
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
/admin_delrecord_saved.asp, line 22
My code is as follows:
<%
delid = Request.Form("delid");
conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("db/products.mdb"))
deleterec = "DELETE tblProducts.ProductID FROM tblProducts WHERE (((tblProducts.ProductID)="+delid+"))";
conn.execute(deleterec);
conn.close;
%>
Any ideas??!
Cheers!