How to delete a database record using ASP

[farooqi123]

I have written an ASP script to delete a database record (MS Access). There is no error in the code but raise the following error at runtime. "No Update Permission". I have tried to set the Inetpub and wwwroot folders as Read and Write by clicking right on these folders, but still this is not working while I can read and insert the records from the database successfully.....

Can any body help me how to set the Update permissions so that I will be able to delete records from database......Thank You

 

[Rockn]

YOu have to set these permissions in IIS since it is the anonymous user account that is doing the access.

 

[farooqi123]

Please can u tell me how to set the permissions in IIS so that I will be able to delete records from MS Access table using ASP. I will be very thankful to you...

 

[Rockn]

If you cannot delete them I am assuming that you cannot add new records either. Go into IIS, right click on the web site you want to edit and select properties. Go to Home Directory tab and set the Execute Permissions to Scripts & Executables and set the IIS Process to low.