How to delete record in a db?

[DeepBlerg]

Hi,

I'd like a user to be able to login to a db and that's all fine but when the user presses a button saying "Finish", how could I make it so a record in a table is deleted?

Thanks very much,
Tim

 

[csilmh]

You Should define the user not as read only user.

Try this code:

'*******************************
'Rs.CursorLocation = adUseClient
'Rs.CursorType = adOpenStatic
'Rs.LockType = adLockOptimistic
'*******************************

before the line Rs,Activeconnection = yourConn

 

[DeepBlerg]

Hi csilmh,

Thanks for that, but that doesn't delete an entry in a form in a database does it? That's what I'm trying to do...

--Tim

 

[sjf]

Easiest way I can think of is to use an SQL statement to delete the required record.
You could set it up so the FINISH button submits a form containing an ID number of the record you want to delete. Post the form to an ASP page that opens the database connection and deletes the record using an SQL statement like this:
"DELETE FROM YOURTABLE WHERE YOURTABLEID IN ("&userIDNo&&quot"

Then redirect the user to another page using
Response.Redirect "URL"

Hope this helps.
sjf