访问表单不能更新或添加记录 [英] Access Form cant update or add records
问题描述
我目前正在创建一个访问表单,但是当我进入表单视图时,我无法更新任何当前记录或添加新记录,任何人都不知道为什么我不能编辑或更新我的记录?或者我怎么去解决这个问题?
I am currently creating a Form on access however when I go into form view I am unable to update any of the current records or add new records would anyone have any idea why I cant edit or update my records? or how I go about fixing this?
我的表单当前链接到一个查询,并将它重要我还在我的表单中包含搜索功能。
My Form is currently linked to a query, and incase it matters I also have inlcuded a search function in my form.
任何帮助/建议将不胜感激。
Any help/advice would be greatly appreciated.
感谢
宝拉
推荐答案
这意味着您使用的查询不可更新。可更新查询设计有很多限制,例如,您不能在查询中使用聚合,连接应该具有唯一键等。尝试重新设计您的查询。作为一种解决方法,您可以将查询中的数据复制到临时表中,编辑此表中的数据,然后将数据复制回主表中。
It means that the query you use is not updateable. There are a lot of limitations for updateable queries design, for instance you cannot use aggregaing in query, joins should have unique keys etc. Try to redesign your query. As a workaround you can copy the data from your query to temporary table, edit the data in this table and then copy data back to main table(s)
这篇关于访问表单不能更新或添加记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!