Operation must use an updateble query

Posted Date: 19 Jun 2012 Posted By:: Surendra Tarai

Member Level: Silver Member Rank: 3088 Points: 3 Responses: 4

I have deployed an application and it support only DQL query but when I try to run DML query like insert/delete/update then it is throwing error:

Operation must use an updateble query

I think the database is read-only.

But I have checked read-only property of database file, but it is also false, still it is not working and same error.

All the best

-Thanks & Regards
Surendra Tarai
+91-9090595512
Syztech Solutions

Responses

#676228 Author: Shivshanker Cheral Member Level: Gold Member Rank: 23 Date: 19/Jun/2012 Rating: Points: 2
Check the User profile which you are using to insert/update query. let us know What error you are getting and which version of SQL and OS so that we can answer your question Thanks Shivshanker Cheral "If you share your assets (money etc..) it will decrease, But if you share your knowledge it will increase!!! ".

#676316 Author: Anil Kumar Pandey Member Level: Platinum Member Rank: 1 Date: 19/Jun/2012 Rating: Points: 2
There may be an issue in the user permission also, make sure by checking the property of the user in the data base. the user must have the Read , Write and Execute property. Thanks & Regards Anil Kumar Pandey Microsoft MVP, DNS MVM

#676325 Author: Prachi Kulkarni Member Level: Gold Member Rank: 33 Date: 19/Jun/2012 Rating: Points: 1
Hi, Can you please provide error screenshot so that it will be more clear? Regards, Prachi.

#676334 Author: sudhajosyula Member Level: Gold Member Rank: 46 Date: 19/Jun/2012 Rating: Points: 2
Is it are you using Microsoft MSAccess ? If so,try to uncheck the read only.It clearly states that it doesnot have write permission.Please find the identity of the app pool with the IIS and give that identity to Network Service to the folder.

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Suggest me how i can save the select query inside the temporary table and retrive it later
	Previous : How to develop a application for petrol bulk
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John