Updating Records Error

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

 

[schase]

Little info would be helpful

Database type
Language
Server type
error number

Chances are your running into a permissions issue

or reserved names.

http://www.macromedia.com/support/ultradev/ts/documents/common_server_errors.htm

"Never underestimate the power of determination"

Stuart

 

[prodoubts]

Database type : MS Access
Language : ASP.NET
Server type : IIS (WIN XP PRO)
error number : I do not see an error number except for the above posted Error

 

[schase]

In Internet explorer,

Goto tools, internet options, advanced tab.

Scroll down to where you see

Show friendly http error messages.

uncheck that,

rebrowse to the page in question and see if it shows a different error "Never underestimate the power of determination"

Stuart

 

[prodoubts]

I did that.
It gives the same error. Infact my options were unchecked.

I tried checking and unchecking and I get the same error.

Later I tried going into the folder through Windows Explorer and when I right clicked on that folder it says Read Only. I unchecked and applied it.

Again when I check it, it says Read Only again.

But in the IIS setting, the permissions are set for it to be writable.

Going crazy with it !

 

[schase]

Sounds like your system is set to parent values
or overwriting objects and subfolders to the value of
the parent.

"Never underestimate the power of determination"

Stuart