XP Pro Maximum Network Connections reached at 5 Computers

[Lis]

Hi All:

I am baffled. I have one XP Pro computer that hosts a shared MS Access
2000 database which it connects directly to via a system DSN. I have 4
additional XP Home computers that can connect to that database
simultaneously with no problems via system DSN as well. All computers
are accessing the DB through a VB application.

I understand the XP Pro will allow up to 10 connections. The problem
is, when I add the 6th XP Home computer to the network & try to access
the same database, the next computer to try to perform an operation on
the DB is locked out.

In addition, none of the XP Home computers are accessing any other
shared resource on the XP Pro computer.

So I am confused. Anyone have any ideas? And, how can I view the
current live connections on my XP Pro computer to see what is going on?

Thanks
Lis

 

[Dave Patrick]

From a command prompt;
net sess

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi All:
|
| I am baffled. I have one XP Pro computer that hosts a shared MS Access
| 2000 database which it connects directly to via a system DSN. I have 4
| additional XP Home computers that can connect to that database
| simultaneously with no problems via system DSN as well. All computers
| are accessing the DB through a VB application.
|
| I understand the XP Pro will allow up to 10 connections. The problem
| is, when I add the 6th XP Home computer to the network & try to access
| the same database, the next computer to try to perform an operation on
| the DB is locked out.
|
| In addition, none of the XP Home computers are accessing any other
| shared resource on the XP Pro computer.
|
| So I am confused. Anyone have any ideas? And, how can I view the
| current live connections on my XP Pro computer to see what is going on?
|
| Thanks
| Lis
|

 

[Yves Leclerc]

XP Pro allows 10 max.

XP Home allows 5 max.

Depending how your system are connecting to each other, if one passes thru a
XP Home PC, then you could be getting this message.

 

[Asher_N]

@g44g2000cwa.googlegroups.com:

It's 10 /connections/, not computers. Each of your XP Home computers may
be opening 2 connections to your XP Pro computer.

 

[Lis]

Yes I know , I said it wrong. I understand it is connections and not
computers. How do I see how many 'connections' each computer is making
to the XP Pro machine?

All of the XP Home computers are connecting directly to the Access
database on the XP Pro machine. They do share resources between
themselves - I mean each XP Home computer is sharing/using a printer on
the other (label printers & deskjet printers) but none of the XP Home
computers is accessing anything other than the database on the XP Pro
computer - or at least it shouldn't be.

Thanks to everyone for help

Lis

 

[Dave Patrick]

From a command prompt;
net sess

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Yes I know , I said it wrong. I understand it is connections and not
| computers. How do I see how many 'connections' each computer is making
| to the XP Pro machine?
|
| All of the XP Home computers are connecting directly to the Access
| database on the XP Pro machine. They do share resources between
| themselves - I mean each XP Home computer is sharing/using a printer on
| the other (label printers & deskjet printers) but none of the XP Home
| computers is accessing anything other than the database on the XP Pro
| computer - or at least it shouldn't be.
|
| Thanks to everyone for help
|
| Lis
|

 

[Lis]

I saw that after I posted the message - Sorry & Thanks - will try
tonite...

Lis

 

[Dave Patrick]

No problem. You can also;
Control Panel|Administrative Tools|Computer Management(local)\System
Tools\Sessions

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I saw that after I posted the message - Sorry & Thanks - will try
| tonite...
|
| Lis
|

 

[Lis]

Ok, I tested it last night and saw 1 connection per computer...however
each connection had 2 files open - the database and lock file (not sure
if that is a problem or not). Since they are all only sharing an
Access database, each connection had the database.mdb and database.ldb
file open. I noticed if one of the 5 computers sat idle for awhile the
connection would be dropped, which would explain why the 6th computer
could gain access, but then when that idle computer 'woke up', then it
would not be able to gain access. So is that really my problem or am I
missing something? And if so, how can I fix it? I'm not real familiar
with how MS Access DB's should be shared over a network so please
forgive my ignorance.

Thanks for any help!!!

 

[Dave Patrick]

It seems you shouldn't be seeing this behavior. What is the error message
you receive? Is there a connection limit on the share itself? Are the
permissions correct on the share? This article explains how to count the
connections.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314882

As far as Access is concerned you should split the database. Then copy the
front-end to each client computer leaving the back-end on the network share.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Ok, I tested it last night and saw 1 connection per computer...however
| each connection had 2 files open - the database and lock file (not sure
| if that is a problem or not). Since they are all only sharing an
| Access database, each connection had the database.mdb and database.ldb
| file open. I noticed if one of the 5 computers sat idle for awhile the
| connection would be dropped, which would explain why the 6th computer
| could gain access, but then when that idle computer 'woke up', then it
| would not be able to gain access. So is that really my problem or am I
| missing something? And if so, how can I fix it? I'm not real familiar
| with how MS Access DB's should be shared over a network so please
| forgive my ignorance.
|
| Thanks for any help!!!
|

 

[Lis]

You said..."Is there a connection limit on the share itself? Are the
permissions correct on the share?"

I have not set a max number of users on the share on the Sharing tab -
is that what you mean? Also, how should the permissions be set up?
All users have full control and the folder itself has the 'Ready for
archiving' checkbox set...is there something else I should check?

Also, by splitting up the front & back end of the DB - will that
eliminate the .ldb file opening? Could it be the way I am opening the
DB thru VB?

Thanks

Lisa
Lisa

 

[Dave Patrick]

:
| You said..."Is there a connection limit on the share itself? Are the
| permissions correct on the share?"
| I have not set a max number of users on the share on the Sharing tab -
| is that what you mean?
* OK sounds good.


Also, how should the permissions be set up?
| All users have full control and the folder itself has the 'Ready for
| archiving' checkbox set...is there something else I should check?
* If the drive is NTFS then you have two places to check pemissions. Share
permissions (sharing tab) and folder and or file permissions (security tab).


| Also, by splitting up the front & back end of the DB - will that
| eliminate the .ldb file opening? Could it be the way I am opening the
| DB thru VB?
* The LDB is a part of Access. One will exist at the location of each opened
MDB
http://support.microsoft.com/kb/208778

You still didn't mention the error message you receive.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect