[AccessD] SQL Server Express - true skinny

John, I have an access 2003 front end with linked tables to SQL 2005
Express backend with up to 25 users hitting it.  No problems at all. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 10, 2010 3:07 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL Server Express - true skinny

I took the 10g right from their web page "comparing versions".

John W. Colby
www.ColbyConsulting.com

On 9/10/2010 3:35 PM, Jim Dettman wrote:
>
> <<So the question is, would SQL Server express be capable of replacing

> Jet for a complex bound application for 30 users?>>
>
>    I've never had occasion to try it myself, but from what I 
> understand, for
> 2005 and up that is correct.  The old 5 connection limit was removed.
>
>    However the DB limit is 4GB, not 10.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Friday, September 10, 2010 2:09 PM
> To: Access Developers discussion and problem solving; Sqlserver-Dba; 
> VBA
> Subject: [AccessD] SQL Server Express - true skinny
>
> Does anyone know the true skinny on the limitations placed on SQL 
> Server express in order to "throttle" it.?
>
> I found a blog that claims that outside of CPU / Memory / DB size 
> limitations, there is not other "governor".
>
> So it appears that the limitations are:
>
> 10 gig db file size.  This does not discuss additional database files.
> 1 CPU.  However it appears that it can use 4 cores if available
> 1 gig of memory.  This appears to be the killer.
>
> But there appears to be no "user" limitations etc.
>
> So the question is, would SQL Server express be capable of replacing 
> Jet for a complex bound application for 30 users?
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************