John Colby
jcolby at colbyconsulting.com
Wed Jun 4 09:50:42 CDT 2003
I have also seen cases where the "auto join" function didn't work in queries without the relationships in the FE. Not often but I have seen it. And that seemed to be an A97 thing. I haven't seen it in A2K or later. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mike and Doris Manning Sent: Wednesday, June 04, 2003 10:41 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] relations in which database No, I've actually run into cases where I had to have the relationships in the FE because it didn't seem to "inherit" them through the BE link. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, June 04, 2003 9:54 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] relations in which database Oh Doris, please tell you did mix some things up here, right? /gustav > In a split Access FE/BE world, the Access BE is nothing but a > container of tables. You can keep a copy of the relationships in the > BE for reference but in order for the FE to do its job properly you > have to have a copy of the relationships in there too. _______________________________________________ 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