建立关系 [英] Create Relationship
本文介绍了建立关系的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的FE数据库中有一个Db(暂时)表和链接的Excel文件。
在关系窗口中,我可以建立一个...之间的关系。访问"表和链接的Excel表表,但显然不能建立参照完整性。我可以忍受。
使用以下代码
I have a Db with (for the moment) tables in my FE database together with linked Excel files.
In the relationship window, I can establish a relationship between an "Access" table and the linked "Excel" table, but obviously can''t establish referential integrity. I can live with that.
Using the following code
展开 | 选择 | Wrap | 行号
推荐答案
我不确定为什么会出现这个错误,但是有一个循环工作。此解决方案的可行性取决于您的具体情况。
I am not exactly sure why this Error is occurring, but there is a work-a-round. How viable this solution is will depend on your specific circumstances.
- 创建一个与您的链接Excel表结构完全相同的表。这将是你的附加表(让我们称之为tblAppend)。
- 在尝试创建任何关系之前删除tblAppend中的所有记录(参考行#15),如:
- Create a Table that is exactly the same structurally as your Linked Excel Table. This will be your Append Table (let''s call it tblAppend).
- DELETE all Records in tblAppend before attempting to create any Relation, (ref Line# 15), as in:
展开 | 选择 | Wrap | 行号
你好ADezii。
为了清楚起见,我可以确认你是建议创建Excel表格的Jet / ACE副本,然后使用它创建一个关系吗?
Hi ADezii.
Just to be clear, can I confirm that you''re proposing to create a Jet/ACE copy of the Excel table and then creating a Relationship using that instead?
你好菲尔。
不太确定如果我诚实的话,那为什么不起作用。我希望代码和界面能够以相同和一致的方式工作。看来你发现他们不会: - (
Hi Phil.
Not really sure why that wouldn''t work if I''m honest. I''d expect the code and the interface to work similarly and consistently. It seems you''ve found they don''t :-(
这篇关于建立关系的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文