Hi I have a web application and I am using MS Access 2003 for my web database. My Database file is located in the App_Data folder. I am using this database file to insert and populate data to my web page. Both of this scenario insert, delete and select statement
works fine on my PC. But whenever I tried to do the same thing where I hosted my web application only select statement would work. Insert or delete won't work, it shows an error message "Operation must use an updateable query". I am not sure why? I am still
a newbie. Can you help?
Hi oned_gk thanks for your respond. Can your please give me some example. I am using windows 7 64 bit. On my local machin it works fine. Please help me.
ijAcK
0 Points
5 Posts
Operation must use an updateable query Error Occur when deploy on a server
Nov 30, 2012 01:19 PM|LINK
Hi I have a web application and I am using MS Access 2003 for my web database. My Database file is located in the App_Data folder. I am using this database file to insert and populate data to my web page. Both of this scenario insert, delete and select statement works fine on my PC. But whenever I tried to do the same thing where I hosted my web application only select statement would work. Insert or delete won't work, it shows an error message "Operation must use an updateable query". I am not sure why? I am still a newbie. Can you help?
Thanks
oned_gk
All-Star
31265 Points
6393 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Nov 30, 2012 01:33 PM|LINK
ijAcK
0 Points
5 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Nov 30, 2012 06:04 PM|LINK
Hi oned_gk thanks for your respond. Can your please give me some example. I am using windows 7 64 bit. On my local machin it works fine. Please help me.
Thanks
oned_gk
All-Star
31265 Points
6393 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Dec 01, 2012 12:16 AM|LINK
It is not coding problem. Try righ click at the folder -> properties -> security -> ....
In IIS right click -> Edit Permission
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Dec 01, 2012 03:36 AM|LINK
Can you show us some codes?
oned_gk
All-Star
31265 Points
6393 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Dec 01, 2012 07:47 AM|LINK
Usualy the problem because the file readonly (or readonly permision)
hans_v
All-Star
35986 Points
6550 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Dec 01, 2012 11:30 PM|LINK
http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error
hans_v
All-Star
35986 Points
6550 Posts
Re: Operation must use an updateable query Error Occur when deploy on a server
Dec 01, 2012 11:34 PM|LINK
It has nothing to do with the code, it is a very common permissions issue, see Mike's article....