Operation must use an updateable query (Permission Set)

[haroldjclements]

I have a problem with writing to my database.

 

The error that I receive is

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

 

I have the permissions on the database and directory that it is in set to �full control� but I still get this error.

 

Does anyone have any ideas?

 

Thanks in advance,

Harold Clements

[Robby]

Can you post your sql statement?

[Joe Mamma]

sounds like you are using access or sql server and have a key word as one of your field or table/view names. . .

 

 

put your database object names in square brackets, like this:

 

string sql = "UPDATE [My Table] Set [Field 1] = 123456789"

 

or if owner qualified:

 

"UPDATE [dbo].[My Table] Set [Field 1] = 123456789"

[haroldjclements]

Problem Solved With Thanks

 

Thanks Robby and Joe, I have sorted the problem now, thanks alot for you help.

 

Harold Clements

[Joe Mamma]

so what was your problem???