Operation must use an updateable query

  • Thread starter Thread starter Blueshift
  • Start date Start date
B

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
 
Back
Top