Jim Dettman
jimdettman at earthlink.net
Wed Jun 4 09:04:43 CDT 2003
Marcel, It depends on what you mean by "relationship". If your not enforcing RI, then the relationships can be anywhere. Their basically a shortcut for creating joins when you use the query designer. If you are enforcing RI, then they *must* be in the backend to work. Putting them in the front end achieves nothing additional other then what I stated above. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Marcel Vreuls Sent: Wednesday, June 04, 2003 8:57 AM To: accessd at databaseadvisors.com Subject: [AccessD] relations in which database Dear group, I am stugling with the following. In our current situation I have a FE and a BE database. The relationships are currently stored in the BE database. Now the question is why not put them in the FE database and just leave the plain tables in the be database. Advantages should be - performance in multiuser env. - more control over the database because with each update you can change, add a relationship - peoplo who want to access the database through excel, and so on have more trouble in comprending the database. - field updates, new tables are easily to create instead of using 3rd party backend updaters Are there disadvantages??? Thanks, marcel vreuls -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: woensdag 4 juni 2003 13:09 To: AccessD Subject: [AccessD] OT: Canon BJC 4200 printer problems Does anyone have the printer mentioned? If so, would you e-me off-list please? Thanks. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com