sql express: multiple computers accessing same database file?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 06 Apr 2006 20:06 GMT

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

Reply to this Message

Matt Noonan - 07 Apr 2006 01:42 GMT

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.

Signature

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

> 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

Reply to this Message

serge calderara - 07 Apr 2006 13:41 GMT

Hi,

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

regards
serge

> 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
[quoted text clipped - 9 lines]
> >
> > Thanks

Reply to this Message

sql express: multiple computers accessing same database file?

Free Magazines