Operation must use an updateable query

[crabback]

Hi

I have a web app that uses an access database. I have set the security permission for the iusr account on the database folder, subfolder and files, yet when I try to change data on the web page I get this error:
Operation must use an updateable query.
I don't know why this error is happening as I have set my permissions.
I have deleted and recreated my databases in case there was something there causing the error... but I STILL get it.

Can anyone shed any light on this???

Thanks in advance


Crabback

 

[BoulderBum]

iusr is the account IIS runs under, which isn't necessarily the account that is accessing your database.

By default, the ASP.NET worker process runs under "aspnet_user" for Windows XP or "Network Service" for Windows Server 2003. Try configuring permissions for the worker process account.

Also see here:

http://forums.asp.net/t/154273.aspx

MCP, MCTS - .NET Framework 2.0 Web Applications

 

[crabback]

Hi,

I'm still having an issue whenever I try to run an Update/Insert/Delete query against my database.
I get the following error:
Operation must use an updateable query
I am using IIS 5, and my database is Access.
I have set the security permissions on my database folder to allow the aspnet account modify permissions... But I still get the same error.

any thoughts?
Crabback


Crabback

 

[SeanSeverson]

I, too have the problem with updating an MS Access database from my ASP.NET (webservice) application. I have set full permissions for the ASP.NEt and the IUSR_<Machine Name> account and I am still unable to update the database.

Incidentally, when I copy my code to a windows application, I am able to update the database just fine.

I am running the application on my laptop (Windows XP Pro) which is part of my work Domain, but I am off of the network at this point (if that matters).

I have seen other posts where others claim to have fixed the problem, but have not posted what they did as the solution. I even consulting with one of the networking technicians at my company and we still could not get this to work.

Any other suggestions?

 

[crabback]

My issue was that my hosting company sets a dsn connection to the database - so the permissions were ineffective because of the way I had written connection.

I had been using the accessDataSource to access the database, but with the dsn I have to use system.data.odbc - which doesn't work with the accessDataSource so I had to change to sqlDataSource.
I have discovered however, the dsn connection very unreliable - I am having probs updating memo fields in my database because the sqlDataSource sees this as a text field so will only allow updates of up to 255 chars. Also I had to rewrite all my parameters.
I'm looking at changing hosting companies at this stage.

Crabback