Re: Operation must use an updateable query.

From: Alphonse Giambrone (NOSPAMa-giam_at_example.invalid)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 14:31:13 -0400

I just ran into this one a few days ago.
You need to have write permission for the database file/folder. 

-- 
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Pravin A. Sable" <pravin@ccs.neu.edu> wrote in message
news:%23tUTTnULEHA.556@TK2MSFTNGP10.phx.gbl...
> Dear All,
>
>
> Please find the source code for this error in attachment.
>
> I am trying to execute following code
>
>   Sub SubmitBtn_Click(ByVal Sender As Object, ByVal E As EventArgs)
>          Dim DBConn As OleDbConnection
>          Dim DBInsert As New OleDbCommand
>          DBConn = New OleDbConnection("PROVIDER=" _
>              & "Microsoft.Jet.OLEDB.4.0;" _
>              & "DATA SOURCE=" _
>              & Server.MapPath("Emps.mdb;"))
>          DBInsert.CommandText = "Insert Into Employees " _
>              & "(LastName, FirstName, PhoneNumber, EmailAddress, " _
>              & "Notes, DepartmentID) values (" _
>              & "'" & Replace(txtLastName.Text, "'", "''") & "', " _
>              & "'" & Replace(txtFirstName.Text, "'", "''") & "', " _
>              & "'" & Replace(txtPhoneNumber.Text, "'", "''") & "', " _
>              & "'" & Replace(txtEmailAddress.Text, "'", "''") _
>              & "', " _
>              & "'" & Replace(txtNotes.Text, "'", "''") & "', " _
>              & ddlDepartments.SelectedItem.Value & ")"
>          DBInsert.Connection = DBConn
>          DBInsert.Connection.Open()
>          DBInsert.ExecuteNonQuery()
>          Response.Redirect("./index.aspx")
>      End Sub
>
> while executing following
>          DBInsert.ExecuteNonQuery()
>
> query is
> Insert Into Employees (LastName, FirstName, PhoneNumber, EmailAddress,
> Notes, DepartmentID) values ('asdfas', 'asdf', 'asdfasfdasdf', 'asf',
> 'asdfasdf', 3)
>
>
> I get an error saying as follows, Whats happening... it's new to me..
> more to that its an example striaght copy paste from one book.
>
>
>
> Operation must use an updateable query.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.Data.OleDb.OleDbException: Operation must use
> an updateable query.
>
> Source Error:
>
>
> Line 58:         DBInsert.Connection = DBConn
> Line 59:         DBInsert.Connection.Open()
> Line 60:         DBInsert.ExecuteNonQuery()
> Line 61:         Response.Redirect("./index.aspx")
> Line 62:     End Sub
>
>
> Source File: c:\inetpub\wwwroot\WebApplication1\add1.aspx.vb    Line: 60
>
> Stack Trace:
>
>
> [OleDbException (0x80004005): Operation must use an updateable query.]
>     System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32
hr)
>
>
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> dbParams, Object& executeResult)
>     System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&
executeResult)
>     System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior
> behavior, Object& executeResult)
>     System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> behavior, String method)
>     System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
>     WebApplication1.add1.SubmitBtn_Click(Object Sender, EventArgs E) in
> c:\inetpub\wwwroot\WebApplication1\add1.aspx.vb:60
>     System.Web.UI.WebControls.Button.OnClick(EventArgs e)
>
>
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String
> eventArgument)
>     System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
>     System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
>     System.Web.UI.Page.ProcessRequestMain()
>
>
>
>