Home All Groups Group Topic Archive Search About

sql express: multiple computers accessing same database file?

Author
6 Apr 2006 7:06 PM
David
For sql express, can multiple computers access  same database file on
a shared network drive?  This is for a small client with 3-5
computers.  I do not wish to use Express if I am heading into
multi-user issues

Thanks

Author
7 Apr 2006 12:42 AM
Matt Noonan
I'm not a SQL Express expert, but I wouldn't do it that way. Better to
install SQL Express on the common machine and then connect the clients to
the common SQL Server instance. I'm not sure of the multi-user restrictions
on SQL Express, but it should be able to handle 3-5 users.

Others can correct me if I am wrong.

--
Matt Noonan
EasyObjects.NET: The O/RM for the Enterprise Library
http://www.easyobjects.net


Show quote
"David" <dm***@sbcglobal.net> wrote in message
news:uhpa321rkiihb3gijrcj50a192auvuded3@4ax.com...
> For sql express, can multiple computers access  same database file on
> a shared network drive?  This is for a small client with 3-5
> computers.  I do not wish to use Express if I am heading into
> multi-user issues
>
> Thanks
>
Author
7 Apr 2006 12:41 PM
serge calderara
Hi,

Check this out :
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

regards
serge


Show quote
"Matt Noonan" wrote:

> I'm not a SQL Express expert, but I wouldn't do it that way. Better to
> install SQL Express on the common machine and then connect the clients to
> the common SQL Server instance. I'm not sure of the multi-user restrictions
> on SQL Express, but it should be able to handle 3-5 users.
>
> Others can correct me if I am wrong.
>
> --
> Matt Noonan
> EasyObjects.NET: The O/RM for the Enterprise Library
> http://www.easyobjects.net
>
>
> "David" <dm***@sbcglobal.net> wrote in message
> news:uhpa321rkiihb3gijrcj50a192auvuded3@4ax.com...
> > For sql express, can multiple computers access  same database file on
> > a shared network drive?  This is for a small client with 3-5
> > computers.  I do not wish to use Express if I am heading into
> > multi-user issues
> >
> > Thanks
> >
>
>
>

AddThis Social Bookmark Button