Inserting Problem: Error -Operation must use an updateable query........

• • Reply

  13 years ago

  by nib

  Baye kito

  Addis Ababa, Ethiopia

  Joined 14 years ago

  I am getting the message when i try to insert data into an access table.

  I used dreamwaver MX to build the inserting aspx page.

  System.Data.OleDb.OleDbException: Operation must use an updateable query.
  at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
  at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
  at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
  at DreamweaverCtrls.DataSet.DoInit()
  
  
  
  
  
  
  

  What could be the solution?

   

  Report abuse
• • Reply

  13 years ago

  by postmaster

  postmaster

  , United States

  Joined 14 years ago

  Post your SQL Statement.

  -Postmaster

  http://www.programmingknowledge.com/

   

   

  Report abuse
• • Reply

  13 years ago

  by nib

  Baye kito

  Addis Ababa, Ethiopia

  Joined 14 years ago
  CommandText='<%# "INSERT INTO ADD (ADDRESS, CITY, CODE, FAX, LOCATION_NAME, REGION_ID, TELEPHONE) VALUES (?, ?, ?, ?, ?, ?, ?)" %>'
  ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_Connection"] %>'
  DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_Connection"] %>'
  Expression='<%# Request.Form["MM_insert"] == "Detail" %>'
  CreateDataSet="false"
  
  
  
  
  Report abuse