We are trying to evaluate the use of SQL Server as a back-end and
although the system works with a very small number of users we are
encountering difficulties when the number rises to about 8-10. If we
cannot overcome these we will revert to Access back-end.

If we are successful, the licenses will be acquired for Enterprise
edition. There is no intention of violating licences. We do however
wish to test the system fully before advancing.

As I said in my original post, I am happy to explore the problem in
another post. I just wanted to eliminate the possibility that the use
of the Developer version was contributing to the problem.


Erland Sommarskog wrote:
> Jim Devenish (internet.shopping@foobox.com) writes:
> > I am having some problems in the process of moving an Access back-end
> > to an SQL Server back-end. Everything works but there are severe
> > problems of response times when the number of users builds up.
> >
> > At present we are using the Developer version before committing to the
> > Enterprise version. BOL (quoted below) seems to suggest that, apart
> > from licensing, they are the same.
> >
> > Can anyone please confirm that this is so. If not, what is the
> > difference?
>
> The difference is exactly in the license. And when you mention users
> building up, I get a little vervous that you are violating it...
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx