<% y = request.form("logonid") %> <% ' THIS IS ASP CODE FOR A DSN-LESS CONNECTION (DSN = data source name) dim conntemp, rstemp 'Declare all variables accessdb="fgp2.mdb" 'Specify Database, Driver, path... myDSN="DRIVER={Microsoft Access Driver (*.mdb)};" ' MS Access driver myDSN=myDSN & "DBQ=" & server.mappath(accessdb) ' Map path to DB mySQL="DELETE * FROM Table1 WHERE Logonid = '" & y & "'" set conntemp=server.createobject("adodb.connection") 'Set a temporary connection (conntemp) conntemp.open myDSN 'Open the connection set rstemp=conntemp.execute(mySQL) 'Exec SQL and count fields - build a temporary recordset (rstemp) %> Logonid <% response.write(y) %> deleted