问题描述
大家好，
在使用我的应用程序之前，我对关系理论有疑问。
我之前的应用程序已经完成在Access 97中，我根本没有使用关系。
我的后端数据库中有65个表，如果你添加了
关系，则使用Access 97它会在
及以上添加相同关系的多个副本，所以我决定不使用任何关系。
另外，当我需要时通过代码添加或删除字段，它很多没有关系，因为你没有必要担心在添加新字段或删除时添加
关系他们如果你需要
删除一个过时的字段。
所以问题是，我即将部署应用程序，重新进入访问
2007，并且使用65个表，后端
数据库中的关系屏幕非常满。我认为这么多的关系会实际上减缓数据库的速度，并且会使桌面维护更加困难。
任何人都可以给我他们的意见，利弊，关于是否有
关系？
非常感谢，
-
Andy
Hello all,
Prior to going live with my app, I have questions on relationships theory.
My prior app was done in Access 97, and I did NOT use relationships at all.
I have 65 tables in my back-end database, and with Access 97, if you added
relationships, it would add multiple copies of the same relationships over
and over, so I decided not to use any relationships at all.
Additionally, when I needed to add or remove fields via code, it was a lot
easier without relationships, as you didn''t need to worry about adding
relationships when adding new fields, or removing them if you needed to
delete an obsolete field.
So the question is, I''m about to deploy the app, re-worked in in Access
2007, and with the 65 tables, The relationships screen in the back-end
database is very full. I would think that so many relationships would
actually slow the database down, and would make table maintenance much more
difficult in the future.
Can anyone give me their opinions, pros and cons, on whether to have
relationships or not?
Many thanks,
--
Andy
推荐答案
这篇关于关系问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！