[AccessD] Access FE & MSDE BE?

Charlotte Foust cfoust at infostatsystems.com
Tue Mar 15 18:01:07 CST 2005


I thought the limit was on connections, not users.  BTW, I've only worked with full SQL Server, so that isn't a smart aleck remark.

Charlotte Foust


-----Original Message-----
From: Christopher Hawkins [mailto:clh at christopherhawkins.com] 
Sent: Tuesday, March 15, 2005 3:45 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Access FE & MSDE BE?


20, which puts us juuuuuust shy of the 25 limit.  Still, that makes me nervous.  Is the performance throttling gradual (i.e. it gets worse the closer you get to 25) or sudden (i.e. you hit 25, your app blows up).

Anything else I should be wary of?

-C-

----------------------------------------
 From: "Jim DeMarco" <Jdemarco at hudsonhealthplan.org>
Sent: Tuesday, March 15, 2005 2:04 PM
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Subject: RE: [AccessD] Access FE & MSDE BE? 

You're probably already aware of the connection limitation. How many users on this app?

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher Hawkins
Sent: Tuesday, March 15, 2005 3:54 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access FE & MSDE BE?

I've been reading up on MSDE on Microsoft's site, but I'm aware that there is plenty of "market-tecture" in those white papers.  I need to talk to developers who have actually used it, as I'm preparing to upgrade a client from an Access back-end with a history of record corruption.

What kind of issues have you all encountered when using MSDE as a back-end for an Access DB?  Any gotchas?  Horror storeis?  Big wins?

-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".
***********************************************************************************

-- 
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