MS ACCESS 2016 - 无法从表格访问链接表 [英] MS ACCESS 2016 - CAN'T ACCESS LINKED TABLE FROM A FORM
问题描述
HI
我有以下配置:
ACCESS 2016 / WIN 10
ACCESS 2016 / WIN 10
MYSQL 5.7
MYSQL 5.7
我在Access中有一个链接的可更新视图(多个表上的内连接)。只有视图主表中的列以我创建的自定义表单公开,使用VB进行排序等。
I have a linked updateable view (inner joins on multiple tables) in Access. Only columns in the primary table of the view are exposed in a custom form I have created that uses VB for sorting, etc.
- 我可以在Access中打开视图并更新recs。
- I can open the view in Access and update recs.
- 我可以从视图创建表格形式并更新recs。
- I can create a tabular form from the view and update recs.
- 但是当我通过自定义表单更新时,我收到错误# 1221。
- But when I update thru my custom form, I get an error #1221.
我在自定义表单中做的不多,所以我不知道错误发生的原因......
I'm not doing a lot in the custom form, so I'm at a loss as to why the error occurs...
提前致谢...
推荐答案
更新
我也收到错误#1393,所以表格似乎试图更新多个基表,即使我只更新一个表中的字段。
I'm also getting an error #1393, so it seems that the form is trying to update more than one base table, even though I only update fields from one table.
另外,在我的一个表单中,我删除了联接表中的所有字段并且能够更新。当我添加字段时,我仍然可以更新。但在其他形式,我有同样的问题。
Also, in one of my forms, I deleted all fields from the joined table and was able to update. When I added the fields back, I could still update. But in other forms, I have the same problem.
访问有点不一致......
Access is somewhat inconsistent...
这篇关于MS ACCESS 2016 - 无法从表格访问链接表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!