Operation must use an updateable query

[Blueshift]

I have a small ASP.NET Web App using VB.NET and am trying
to utilize an Access database, but cannot perform any
updates, inserts or deletes to the database. Only SELECT
clauses work. It throws the error on the following lines
that I have tried with an OleDbCommand object:

Error:
Operation must use an updateable query

Lines Attempted:

objDataComm.ExecuteReader()
objDataComm.ExecuteNonQuery()
objDataComm.ExecuteScalar()

I have read resolutions on changing the process model of
the ASP.NET worker process, but have no idea how it is
done, or if there are any other clear solutions to this.
Thanks.

Blueshift

 

[Teemu Keiski]

Hi,

see the following thread at ASP.NET Forums. All the information you need is
located there
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=154273