upgrade/delete record fails in server

[dummyagain]

I can run my website in localhost and able to update/delete the record in the gridview. However, when it put the programs to the webserver, there are errors on updating ir or deleting it. I wonder if it's database problem but i can show the records.

I would like to seek your advice for the solution of this problem.

Thank you

[jasonli]

Can you post the detail of errors? That would be helpful to solve it.

[dummyagain]

The error is like cannot access the database. But i am so curious that i can get the data to gridview but why cannot upgrade or delete record.

Thank you

[HairyMonkeyMan]

What kind of database is it?

Does the database user have privs to update and delete records?

Tell us more about your program, maybe show us some databinding code if you need more help.

:wave: regards

[dummyagain]

I am using SQL Server Express Edition. I don't know if my server is protected with update or delete functions, how can i check that?

I think the code for databinding function should be ok since i can run the function in the localhost..but just cannot do it in the webserver... that's the place i found it odd.

Thank you

[jasonli]

You add database file attached in web project, right? If so, maybe because you didn't set Write/Modify access right of the file to NETWORK SERVICE account.

[dummyagain]

Yes, you are right. How can i set the write/update privileges?

Thank you

[jasonli]

go to the website folder on webserver and find the DB file or the folder, set access right in "sharing and security...".

[dummyagain]

i tried it before but still cannot work...