Operation must use an updateable query.

The folder that contains the database (.mdb) file must have MODIFY
permission granted to the user account under which ASP.Net is running.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Pravin A. Sable" <pravin@dotnet.itags.org.ccs.neu.edu> wrote in message
news:#tUTTnULEHA.556@dotnet.itags.org.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.ExecuteCommandTextE rrorHandling(Int32
hr)
>
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
> dbParams, Object& executeResult)
> System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
executeResult)
> System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
> behavior, Object& executeResult)
> System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(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.IPo stBackEventHandler.RaisePo
stBackEvent(String
> eventArgument)
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
> sourceControl, String eventArgument)
> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
> System.Web.UI.Page.ProcessRequestMain()
>It's a WinXP machine. I don't option to set permission for modify etc. I
can just make user a limited user or administrator. I have made all the
users administrator. What else should I do?

Kevin Spencer wrote:

> The folder that contains the database (.mdb) file must have MODIFY
> permission granted to the user account under which ASP.Net is running.
Sounds like you need to disable Simplified File Sharing on your machine to
see the Security tab. The following MS article tells you how:

http://support.microsoft.com/default.aspx?kbid=307874

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Pravin A. Sable" <pravin@.ccs.neu.edu> wrote in message
news:u5er$sXLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> It's a WinXP machine. I don't option to set permission for modify etc. I
> can just make user a limited user or administrator. I have made all the
> users administrator. What else should I do?
> Kevin Spencer wrote:
> > The folder that contains the database (.mdb) file must have MODIFY
> > permission granted to the user account under which ASP.Net is running.
Pravin,

Kevin is correct. That is the exact problem I ran into. Turning off simple
file sharing adds the security tab to the properties for the folder and
file. You can then set permissions for the asp.net account.

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us

"Pravin A. Sable" <pravin@.ccs.neu.edu> wrote in message
news:u5er$sXLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> It's a WinXP machine. I don't option to set permission for modify etc. I
> can just make user a limited user or administrator. I have made all the
> users administrator. What else should I do?
> Kevin Spencer wrote:
> > The folder that contains the database (.mdb) file must have MODIFY
> > permission granted to the user account under which ASP.Net is running.