操作必须使用可更新的查询. (Microsoft JET数据库引擎) [英] Operation must use an updateable query. (Microsoft JET Database Engine)

问题描述

你好，
我正在使用MS Access 2007在Windows窗体中构建应用程序.任何机构都可以帮助解决以下问题:操作必须使用可更新的查询"


在此先感谢！

解决方案

选中此 [ ^ ]它将帮助您

<很有可能，您的SELECT查询不会返回您正在查询的表的主键.您确实在表中有一个主键列，对吧?如果没有，则最好创建一个.

没有主键列，就无法唯一标识表中的每条记录，这使得UDPATE和DELETE sql语句可以找到这些记录.

这就是为什么您收到错误消息的原因...

Microsoft Access不支持可能是问题的完整T-SQL指令集.我遇到了尝试在MS Access数据库上使用IF EXISTS(....)的问题.

Hello,
I am building the application in windows forms with MS Access 2007. Can any body help to sort out the problem of i.e. "Operation must use an updateable query"


Thanks in Advance!

解决方案

Check this[^] it''ll help you

Chances are, your SELECT query isn''t returning the primary key of the table you''re querying. You DO have a primary key column in the table, right?? If not, you better create one.

Without the Primary Key column, there''s no way to uniquely identify every record in the table, which allows UDPATE and DELETE sql statements to find those records.

That''s why you''re getting the error message...

Microsoft Access does not support the full T-SQL instruction set that might be the problem. I encountered that trying to use IF EXISTS(.... on an MS Access Database.

这篇关于操作必须使用可更新的查询. (Microsoft JET数据库引擎)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！