Susan Zeller
szeller at cce.umn.edu
Tue Apr 1 15:35:39 CST 2003
Arthur, how can you drop a statement like that without more info. What do you mean they are dead? Is something else going to come to life in their place? Should I be preparing for this in some way? --Susan -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Tuesday, April 01, 2003 3:02 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] ADP vs Access mdb/SQL Unfortunately, ADPs are dead. (Don't quote me on that, just take my word for it.) "Those who would sacrifice liberty for security deserve neither." -- Benjamin Franklin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Zeller Sent: April 1, 2003 3:05 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] ADP vs Access mdb/SQL In my expereince ADP's are significantly faster than MDB's for the FE b/c ADP uses OLEDB connection. I've found ODBC connections to be very slow. Once in an ADP, start making sprocs do all the work. You can make sprocs very efficient and then your application will be at lightening speed. --Susan -----Original Message----- From: Jim DeMarco [mailto:Jdemarco at hshhp.org] Sent: Monday, March 31, 2003 12:03 PM To: AccessD (E-mail) Subject: [AccessD] ADP vs Access mdb/SQL We had an app (mdb FE/mdb BE) that was performing horribly across a WAN. We moved the BE into SQL Server 2K which helped a bit but I'm wondering if converting the FE to an ADP would do this one step better (this after reading Arthur's excellent article on TechRepublic.com, thanks to Francisco for the pointer). Anyone have an idea? Thanks, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan ************************************************************************ *********** "This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ************************************************************************ *********** _______________________________________________ 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