PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET sql express: multiple computers accessing same database file?

Reply

sql express: multiple computers accessing same database file?

 
Thread Tools Rate Thread
Old 06-04-2006, 08:06 PM   #1
David
Guest
 
Posts: n/a
Default sql express: multiple computers accessing same database file?


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 With Quote
Old 07-04-2006, 01:42 AM   #2
Matt Noonan
Guest
 
Posts: n/a
Default Re: sql express: multiple computers accessing same database file?

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_fw@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
>



  Reply With Quote
Old 07-04-2006, 01:41 PM   #3
=?Utf-8?B?c2VyZ2UgY2FsZGVyYXJh?=
Guest
 
Posts: n/a
Default Re: sql express: multiple computers accessing same database file?

Hi,

Check this out :
http://www.microsoft.com/sql/prodin...e-features.mspx

regards
serge


"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_fw@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
> >

>
>
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off