If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Question regarding relationships
I have a networked database that I have split into a front-end and back end.
The front-end being the queries, forms, reports, code, etc. in a mde file and the back-end being just the tables with data in a mdb file. My question is regarding relationships. Is it better to have the relationships stored in the front-end or back-end or does it matter ? If it is one over the other what are the benefits ??? Any guidance or assistance on this question would be really appreciated. |
#2
|
|||
|
|||
On Fri, 26 Aug 2005 05:18:37 GMT, "Don Garry"
wrote: Is it better to have the relationships stored in the front-end or back-end or does it matter ? They must be defined in the backend. Relations defined in the frontend are decorative only. If it is one over the other what are the benefits ??? Relationships, to be enforced, must be in the same database as the tables that they relate; because if a relationship is defined in A.MDB to enforce relational integrity between tables in Z.MDB, there is no way that A.MDB can do anything to enforce those relationships, if someone opens Z.MDB directly (or from QRSTU.MDB). John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query Relationships Question | Simon | Running & Setting Up Queries | 2 | July 4th, 2005 01:55 AM |
Relationships getting redefined? | raylitalo | General Discussion | 3 | December 15th, 2004 08:31 PM |
Setting Table Relationships- Why? | el zorro | Database Design | 4 | November 8th, 2004 10:29 PM |
Relationships cardinality and . . (Newbie) | Lionel | New Users | 3 | September 26th, 2004 06:29 AM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |