I have used setup and deployment project to build setup. And then i set up my software. When i run it, I am getting error "Operation must be an updatable query."
So I checked permission of app_data folder. There was no full permission to user so I gave permission to it and then run software again.
It worked fine...!
But now problem is that after publishing my software, I cant tell everyone to follow it. So rather than to do it manually, How to give full permission to app_data folder automatically ???
Are you using VS2010 or above? If yes , open your solution as administrator and then try to create again your setup. (start>>VS2010>>right click>>run as administrator )
Are you using VS2010 or above? If yes , open your solution as administrator and then try to create again your setup. (start>>VS2010>>right click>>run as administrator )
Yes, I am using VS2010...
I did it as per u said but still same problem...
But now problem is that after publishing my software
You need to contact your hosting provider. Sometimes they provide a different folder (ussualy outside of the root of your website) where you can put your Access databases. Off course you need to change the connectiionstring to your database accordingly,
but your hosting provider should be able to help you out
jeeten.parma...
Member
77 Points
101 Posts
Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 03:28 AM|LINK
I have used setup and deployment project to build setup. And then i set up my software. When i run it, I am getting error "Operation must be an updatable query."
So I checked permission of app_data folder. There was no full permission to user so I gave permission to it and then run software again.
It worked fine...!
But now problem is that after publishing my software, I cant tell everyone to follow it. So rather than to do it manually, How to give full permission to app_data folder automatically ???
It is urgent, please help me...
Thank you...
roshcha
Member
144 Points
31 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 03:47 AM|LINK
hi,
Are you using VS2010 or above? If yes , open your solution as administrator and then try to create again your setup. (start>>VS2010>>right click>>run as administrator )
jeeten.parma...
Member
77 Points
101 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 04:14 AM|LINK
Yes, I am using VS2010...
I did it as per u said but still same problem...
roshcha
Member
144 Points
31 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 04:44 AM|LINK
Hi,
if administrator have access to "App_Data" folder defiantly problem will be solved
jeeten.parma...
Member
77 Points
101 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 04:45 AM|LINK
Still same problem...
roshcha
Member
144 Points
31 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 04:48 AM|LINK
Hi,
Instruction of this article may help for you.
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 be an updatable query : permission problem with app_data folder
Jan 24, 2013 10:56 AM|LINK
You need to contact your hosting provider. Sometimes they provide a different folder (ussualy outside of the root of your website) where you can put your Access databases. Off course you need to change the connectiionstring to your database accordingly, but your hosting provider should be able to help you out
jeeten.parma...
Member
77 Points
101 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 11:56 AM|LINK
I am running it on my pc...
if i go on app_data folder and give permission manually then it is working fine...
hans_v
All-Star
35986 Points
6550 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 01:05 PM|LINK
Off course,, so what is the problem?
jeeten.parma...
Member
77 Points
101 Posts
Re: Operation must be an updatable query : permission problem with app_data folder
Jan 24, 2013 02:49 PM|LINK
I will do it on my pc, but I can't tell to do it to my every client... I want any pure solution...