About updateable query!

Results 1 to 3 of 3

Thread: About updateable query!

  1. #1
    Join Date
    Dec 1969

    Default About updateable query!

    Hi, I have struggle in this problem for a long time.Can anyone help me?<BR>Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.<BR>Keep popping up when running the codees below:<BR><BR>Public Overrides Sub Add2Table(ByVal ds As clsDataServer)<BR> Dim sql As String<BR> Dim cmdInsert As New OleDbCommand()<BR><BR> sql = "INSERT INTO " & ds.Table _<BR> & "(departmentID, name, description) VALUES " _<BR> & "(@DepartmentID,@Name, @Description);"<BR><BR> cmdInsert = New OleDbCommand(sql, ds.Con)<BR> cmdInsert.Parameters.Add("@departmentID", mDepartmentID)<BR> cmdInsert.Parameters.Add("@name", mName)<BR> cmdInsert.Parameters.Add("@Description", mDescription)<BR> ds.Con.Open()<BR> cmdInsert.ExecuteNonQuery()<BR> ds.Con.Close()<BR> End Sub<BR><BR>Thanks a lot!<BR>Donna

  2. #2
    Join Date
    Dec 1969

    Default Check File Permissions

    on the .mdb file - betcha its read-only, or IUSR doesnt have permissions to modify the file...

  3. #3
    Join Date
    Dec 1969

    Default RE: About updateable query!

    Have you checked to make sure that the database has been set up for read AND WRITE access to the web user account?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts