[ASP.NET]在IIS底下對Access執行資料異動,傳回錯誤訊息(System.Data.OleDb.OleDbException: 運作必須使用更新查詢。 於 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) 於 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) 於 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) 於 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) )(Access under IIS to perform data movement returned an error message (System.Data.OleDb.OleDbException:. Operation must use an update query to System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling (OleDbHResult hr) in System.Data.OleDb.OleDbCommand .ExecuteCommandTextForSingleResult (tagDBPARAMS dbParams, Object & amp; executeResult) in System.Data.OleDb.OleDbCommand.ExecuteCommandText (Object & amp; executeResult) in System.Data.OleDb.OleDbCommand.ExecuteCommand (CommandBehavior behavior, Object & amp; executeResult)))

問題

---

在IIS底下對Access執行資料異動,傳回錯誤訊息 System.Data.OleDb.OleDbException: 運作必須使用更新查詢。 於 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) 於 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) 於 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) 於 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) )(Access under IIS to perform data movement returned an error message (System.Data.OleDb.OleDbException:. Operation must use an update query to System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling (OleDbHResult hr) in System.Data.OleDb.OleDbCommand .ExecuteCommandTextForSingleResult (tagDBPARAMS dbParams, Object & amp; executeResult) in System.Data.OleDb.OleDbCommand.ExecuteCommandText (Object & amp; executeResult) in System.Data.OleDb.OleDbCommand.ExecuteCommand (CommandBehavior behavior, Object & amp; executeResult)))

查看事件檢視器如下：

原因是沒有權限造成！！

解決方法

---

打開檔案總管=>點選上方的"工具"=>資料夾選項=>檢視=>"使用簡易的檔案共用"將這個勾勾取消掉

之後按下確定
再把你的access資料庫檔案=>右鍵"內容"=>安全性
預設是只能讀取跟執行

設定User這個帳號可以寫入