Operation must use an updateable query

[S. Han]

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.

 

[Ken Cox [Microsoft MVP]]

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/default.aspx?scid=kb;en-us;316675

 

[S. Han]

That was it. I gave a write access to the .MDB file for
<MYMACHINENAME>\IIS_WPG user and it worked beautifully. Thank you.