更新Access数据库中的表时出错 [英] error on update the table in access db

问题描述

我正在使用以下语法更新访问db中的表

i am using following syntax for update the table in access db

OleDbCommand cm = new OleDbCommand("update Count1 set Count1.Cot=(select sum(temp.Qty) from temp where temp.Itemcode=" + re11[0].ToString() + ") where Count1.ItemCode="+re11[0].ToString()+"", con);
               cm.ExecuteNonQuery();

我收到以下错误，因为

i got the following error as

Operation must use an updateable query 

我该如何解决，请帮我


谢谢&问候
dineshkumar R

how can i solve it pleas help me


Thanks & Regards
dineshkumar R

推荐答案

验证您的访问文件是否具有写权限.

此链接将帮助您
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107 [ ^ ]

verify your access file have write permission.

this link will help you
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107[^]

这篇关于更新Access数据库中的表时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！