Saturday, March 24, 2012

Operation must use an updateable query

I'm getting an "Operation must use an updateable query" error from my
asp.net page. The strange part is that it doesn't happen in Debug mode
within the IDE (we're using Whidbey Beta 2), but happens when you deploy the
pages to the site. Any pointers as to what to look for would be appreciated.That's usually because the account being used to run ASP.NET doesn't have
Change permissions on the directory where the .MDB is located. When you're
running in debug mode, you're probably passing through your credentials
which allow everything required.
PRB: Cannot connect to Access database from ASP.NET
http://support.microsoft.com/defaul...kb;en-us;316675
"S. Han" <none@.no.where> wrote in message
news:421d078d$1@.news.microsoft.com...
> I'm getting an "Operation must use an updateable query" error from my
> asp.net page. The strange part is that it doesn't happen in Debug mode
> within the IDE (we're using Whidbey Beta 2), but happens when you deploy
> the pages to the site. Any pointers as to what to look for would be
> appreciated.
>
That was it. I gave a write access to the .MDB file for
<MYMACHINENAME>\IIS_WPG user and it worked beautifully. Thank you.
"Ken Cox [Microsoft MVP]" <BANSPAMken_cox@.sympatico.ca> wrote in message
news:O3Aw22fGFHA.3876@.TK2MSFTNGP14.phx.gbl...
> That's usually because the account being used to run ASP.NET doesn't have
> Change permissions on the directory where the .MDB is located. When you're
> running in debug mode, you're probably passing through your credentials
> which allow everything required.
> PRB: Cannot connect to Access database from ASP.NET
> http://support.microsoft.com/defaul...kb;en-us;316675
>
> "S. Han" <none@.no.where> wrote in message
> news:421d078d$1@.news.microsoft.com...
>

0 comments:

Post a Comment