[AccessD] Access FE & MSDE BE?

Have a look at the new version

http://www.microsoft.com/sql/express/


Martin



----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 16, 2005 1:47 AM
Subject: RE: [AccessD] Access FE & MSDE BE?


On 15 Mar 2005 at 19:26, Dan Waters wrote:

> Is this correct?
>
> The 25 limit is not based on the number of people logged on, but on the
> number of client computers concurrently connecting to the MSDE BE.  More 
> can
> be logged on.
>
OK, I've just done it bit more searching.

JC and I are both out of date with our 5. It's 8 in MSDE2000

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnmsde2kwrk/html/msde2000webapp.asp
<quote>
MSDE 2000 employs what is known as a concurrent Workload Governor. The
effect of the governor is to slow certain operations down by stalling user
connections for a few milliseconds whenever there are more than eight
concurrent operations. Some system-generated events in the database engine
count against this eight-operation limit, so the governor may kick in even
when your application code requests fewer than eight operations. The key is
concurrent operations, such as executing a query. This is not the same as
concurrent users.
</quote>

The supposed 25 limit (which appears to be an approximation of how many
users before the slowdown becomes noticeable) comes from a number of
different places including:
http://www.microsoft.com/hk/sql/evaluation/overview/default.mspx
<quote>
SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable
version of SQL Server. Third-party software developers can include it in
applications they build that use SQL Server to store data. MSDE is an ideal
solution for:
Client applications that require an embedded database.
Basic websites that serve up to 25 concurrent users.
</quote>

and http://www.microsoft.com/sql/msde/default.asp
<quote>
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free,
redistributable version of SQL Server that's ideal for client applications
that require an embedded database, new developers learning how to build
data-driven applications, and Web sites serving up to 25 concurrent users.
</quote>

-- 
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com