JWColby
jwcolby at colbyconsulting.com
Fri Feb 2 08:57:49 CST 2007
>Access has the potential for 8 simultaneous connections, but 3 of them are reserved for the system's use. But what does this mean? Where does this come from? I have Bes which have 30-40 Fes connected to them, i.e. have "links" to the tables in them. Is this what you are calling a "connection"? In this case I have 30-40 "connections" to my Bes. IIRC Access has a limit of 255 simultaneous connections, but that has to do with the lock file (the LDB). Each FE with a link to ANY number of tables in the BE has a single lock file entry in the LDB. I have no idea what happens if you run a query that uses the "in X:\MyMDB.mdb", but my assumption is that would share the lock if any, and create a lock if none existed already for that FE. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, February 02, 2007 9:45 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Connections and Performance Access has the potential for 8 simultaneous connections, but 3 of them are reserved for the system's use. That leaves five for users. Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Friday, February 02, 2007 8:02 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Connections and Performance >But, the connection limit for one BE is 5 FE's. What does this mean? I have never heard of any such thing. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, February 02, 2007 8:58 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Connections and Performance I've read several times that maintaining a connection between a FE and a BE will increase the performance of the FE because it doesn't need to reconnect before transferring data. The connection here would be a bound form connected by a table link to a table in the BE. But, the connection limit for one BE is 5 FE's. So, will maintaining connections on more than 5 FE's reduce performance? Seems logical, but I was wondering if this is correct or is there more to it? Thanks! Dan Waters -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com