deleting rows

[dauzat]

Hey, this might sound like a stupid question, but I am new to ASP. I have made a site that is used to list job openings. In order for the user to delete the job opening after the position is taken, I have set up an ID number that Access 2000 assigns automatically. The problem is, I can't set it up to delete by this ID number. Can anyone please help me? Here is the code I am using

*** Declaring variables ***
Dim strID, SQLStmt, con, data_source

*** Receiving values from Form ***
strID = Request.Form("ID&quot

*** Creating Connection Object and opening the database ***
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("../../database.mdb&quot
SQLStmt = "DELETE DISTINCTROW strID FROM employment WHERE (strID ='" & strID & "')"
Set con = Server.CreateObject("ADODB.Connection&quot
con.Open data_source
con.Execute SQLStmt

 

[wushutwist]

Try this:

SQLStmt = "DELETE FROM employment WHERE (strID ='" & strID & "')"

That should work. If it doesn't, then post the exact error you are recieving. In the future be sure to always post the error message, otherwise it is harder for us to help. Wushutwist