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

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.OleDb.OleDbException:
Operation must use an updateable query.

Line 67: cmd.ExecuteNonQuery();

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

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@hotmail.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.OleDb.OleDbException:
>Operation must use an updateable query.
>
>Line 67: cmd.ExecuteNonQuery();
>
>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]

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

Hi Neil,

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

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

http://support.microsoft.com/default...b;en-us;175168

"Neil Zanella" <nzanella@cs.mun.ca> wrote in message
news:b68d2f19.0501221104.52767149@posting.google.c om...[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.OleDb.OleDbException:
> Operation must use an updateable query.
>
> Line 67: cmd.ExecuteNonQuery();
>
> 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]