dotnet thoughts 

a dotnet developer's technical blog

"Operation must use an updateable query" error

I was into developing a website using ASP.Net 2.0 and MS Access. I don’t have IIS installed on my development machine, so I was using default webserver from VS.Net and the code I was written was working fine.

Few days back, I got a Windows 2003 SP1 machine in my network, and I created a Virtual directory and pointed there. But while instering values in to DB I am getting “Operation must use an updateable query” error.  And I got this page.

And I think (I am not sure) it may be because of this “The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the “Everyone” group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.(Microsoft Support)”