[AccessD] Connections and Performance

Dan Waters dwaters at usinternet.com
Fri Feb 2 08:44:39 CST 2007


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




More information about the AccessD mailing list