Jim DeMarco
Jdemarco at hshhp.org
Fri Mar 28 07:23:26 CST 2003
John, MSDE is SQL Server is it not? The KB article I posted yesterday gets into this a bit. Yes it will help with the 5 connection limit provided replication or more than 5 machines does not happen at the same time. If you use indirect this may not be an issue. We're looking into the same thing via a VB front-end. Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, March 27, 2003 9:58 PM To: AccessD Cc: SQLServer Subject: [AccessD] MSDE Replication - Crossposted On a related note... MDSE claims to support replication. I don't know enough about MDSE, never mind replication, to understand the issues - but... If each workstation ran MSDE and the server runs MSDE, then you have effectively created SQL Server for more than "5 simultaneous users". Since each user is now hitting a SQL Server Be on their own machine, with only replication data going to the main BE on the server, it certainly sounds like you could get fairly decent performance for 10 or 20 users. John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ 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 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". ***********************************************************************************