Jim DeMarco
Jdemarco at hshhp.org
Fri Jul 18 07:44:17 CDT 2003
We had an mdb BE with Access 97 FE deployed over a WAN to some remote sites that ran very slowly so we ported the BE to SQL which sped things somewhat up somewhat but we had do a bit of "unbinding" particularly where combo boxes were concerned. Given that I don't see why you shouldn't/couldn't go with a web app unless they're interested in using replication with an Access FE. HTH, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan -----Original Message----- From: Christopher Hawkins [mailto:clh at christopherhawkins.com] Sent: Thursday, July 17, 2003 5:22 PM To: accessd at databaseadvisors.com Subject: [AccessD] SQL Svr BE + Access FE vs. SQL Svr BE + Web FE? A client has an SQL Server database. The db and the server are well-built and adequate to the demands placed upon it. My concern is the client. The database is stored in my client's Chicago HQ. My client has a satellite office in California. The database needs to be accessed by both the Chicago and California users. They want a recommendation as to whether they should use Access as a front-end, or go with a web interface. Actually, that's not true; they want me to validate their existing decision to build the FE with Access, but I'm not comfortable doing that. If I can make a case they'll go with my recommendation instead. I am leaning toward the web interface. But to be honest, I'm not really sure if there's going to be any difference aside from the cost of deployment. What difference in behavior are the users going to see if I present the data to them via an Access FE or via a browser? -Christopher- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (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 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". ***********************************************************************************