Hey,
You can create a small html form and set the value of the specific areas you
want deleted.
then use the below code in a separate .asp file to delete the items for you.
<%
DeleteValue = Request.Form("value")
Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath( "database.mdb" )
lngSQLrs = "DELETE * FROM tablename WHERE fieldname = " & DeleteValue &";"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open lngSQLrs, Con, 3, 3
Con.Close
Set Con = Nothing
%>
Again, this is properly not the most effective way of doing it, but it gives
you a way to delete from the database without having to edit the changes
offline and then upload and overwrite the old database.
--
Regards
Brian H. Madsen
Snr Designer & Developer
Pc Plus Web Design
http://www.pluswebdesign.com.au
Brian@pluswebdesign.com.au