ERROR ! Operation must use an updateable query.

[prodoubts]

I GET THIS ERROR WHEN I AM TRYING TO UPDATE RECORDS USING A FORM.

WHAT SHOULD I DO ?


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()

 

[rac2]

What does your UPDATE statement look like?

 

[Sivagami]

Most cases this is due to permissions for the Internet User on the directory in which the database resides, or the database itself.

Shiva.