Daniel,

We have considered the use of MSDE with some projects and have successfully used MSDE [the database mentioned] for 5-10 user systems, or driving small intranet sites.

Microsoft say that is "Optimised for 5 users", although whilst we cannot confirm this, we believe that this simply relates to the configuration parameters of SQL server when initially installed [which can be changed through the use of SP_CONFIGURE].

I would recommend that it is a good starting point for projects, since you don't need to "lash-out" on SQL Server, but if you find you need to scale up [which is generally a nice problem to have] you can probably justify purchasing the full version.

Regards

 Peter Snipe
 iBase 
 Tel: 01943 603636
 Direct: 01943 886511
 Mobile: 07775 653530
 Fax: 01943 601004
 Web: www.ibase.com
 
 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 This e-mail and/or attachments are for the use of the addressee only. It may contain information that is legally privileged, confidential and/or exempt from disclosure.   All opinions, advice or facts are given without any warranties or intention to enter into a contractual relationship.  Any review, re-transmission, dissemination or other use of, or taking of action in reliance upon this information by persons or entities other than the intended recipient is prohibited.   Please note that any comments or statements made herein may be those of the originator and do not necessarily reflect those of the organisation.
 
 The contents of any attachment to this email could contain a software virus which may damage your computer system. While iBase has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage caused to either your computer system or your business as a result of software viruses spread by email.
 
 If you receive this communication in error please advise the sender immediately and delete all copies of the material.
 


-----Original Message-----
From: Daniel Goren [mailto:[log in to unmask]]
Sent: 01 March 2002 13:31
To: [log in to unmask]
Subject: Database and network/server issues


Is anyone considering the use of Microsoft's limited version of SQLServer
MSDE which is incorporated in Access2000, or have such a system running?

It would be good to hear what size systems are running on it in terms of
no.of users, size of database and weather your running other systems on the
same server such as a mail-server, admin etc.  How much should we avoid
running all these apps on one machine?

Daniel Goren
Information Manager
British Music Information Centre
10 Stratford Place
London, W1C 1BA
t:020 7499 8567
f:020 7499 4795
e:[log in to unmask]
www.bmic.co.uk