Delete a specific record in ASP (MS Access)

[shanuragu]

How can I delete a specific record from an access db table in ASP

Delete From table name Where id=.. not working???

ShaRa

[Bullschmidt]

This code to delete a record has worked for me:

' Delete rec.
' Set sql.
strSQL = "DELETE "
strSQL = strSQL & "FROM tblCust "
strSQL = strSQL & "WHERE (CustID=" & Chr(39) & CustIDOrig & Chr(39) & ")"

' Update.
objConn.Execute strSQL

[Bullschmidt]

Of course, this:
...
can just be coded as follows:

Dave,

You are right of course! I guess using Chr(39) instead of a single quote just feels right to me somehow. Perhaps it's 6 of one, half dozen of the other... :)

[shanuragu]

Thanks

ShaRa

[Bullschmidt]

Glad we could help! :)