SQL updates on MS Access Database: error: Operation must use an updateable query.

**Elton Wang** · Nov 19 '05, 03:35 AM

SQL updates on MS Access Database: error: Operation must use an updateable query.

Hi Neil,

Check out ASPNET account permission to access the folder
that Access database is in. The ASPNET account might only
have permission of Read, but not permission of Write.

Hope it helps.

Elton Wang
elton_wang@hotm ail.com
[color=blue]
>-----Original Message-----
>Hello,
>
>I am trying to update an MS access database from ASP.NET.[/color]
I am using IIS on[color=blue]
>Windows XP Pro. I can issue SELECT statements from[/color]
ASP.NET using ADO.NET but[color=blue]
>I cannot seem to be able to carry out INSERT statements.[/color]
Here is the error[color=blue]
>which I am getting:
>
>Exception Details: System.Data.Ole Db.OleDbExcepti on:
>Operation must use an updateable query.
>
>Line 67: cmd.ExecuteNonQ uery();
>
>I have found some posts where users had a similar problem[/color]
and it seems that[color=blue]
>they were able to resolve it by setting NTFS file[/color]
permissions. However I am[color=blue]
>not sure about how to go about doing this:
>
>I wonder whether someone could please post precise[/color]
instructions on how to[color=blue]
>solve this. I have tried running inetmgr and setting them[/color]
from there but[color=blue]
>I must have done something wrong as I am still getting[/color]
the same error.[color=blue]
>
>Thanks a lot!!!
>
>Neil
>.
>[/color]

**nzanella@cs.mun.ca** · Nov 19 '05, 03:35 AM

Re: SQL updates on MS Access Database: error: Operation must use an updateable query.

Thank you for your reply,

What I ended up doing was I clicked on the MS Access (.mdb) file and
then under Properties -> Securities added an account called Everyone
and set permissions to "Full Control" for this account. So now I can
update the MS Access file via the ASP.NET web interface.

Regards,

Neil

**Ken Cox [Microsoft MVP]** · Nov 19 '05, 03:35 AM

Re: SQL updates on MS Access Database: error: Operation must use an updateable query.

Hi Neil,

This refers to ASP, but the fix is the same if you substitute the ASPNET
account for IUSR_<machinena me>

PRB: ASP Returns 'Operation Must Use an Updateable Query' Error

Error - Office.com

http://support.microsoft.com/default.aspx?scid=kb;en-us;175168

"Neil Zanella" <nzanella@cs.mu n.ca> wrote in message
news:b68d2f19.0 501221104.52767 149@posting.goo gle.com...[color=blue]
> Hello,
>
> I am trying to update an MS access database from ASP.NET. I am using IIS
> on
> Windows XP Pro. I can issue SELECT statements from ASP.NET using ADO.NET
> but
> I cannot seem to be able to carry out INSERT statements. Here is the error
> which I am getting:
>
> Exception Details: System.Data.Ole Db.OleDbExcepti on:
> Operation must use an updateable query.
>
> Line 67: cmd.ExecuteNonQ uery();
>
> I have found some posts where users had a similar problem and it seems
> that
> they were able to resolve it by setting NTFS file permissions. However I
> am
> not sure about how to go about doing this:
>
> I wonder whether someone could please post precise instructions on how to
> solve this. I have tried running inetmgr and setting them from there but
> I must have done something wrong as I am still getting the same error.
>
> Thanks a lot!!!
>
> Neil[/color]

**MOSIMI** · Nov 19 '05, 03:36 AM