Discussion Locked

Maximum Connections to a shared folder

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a W2k Profesional machine running a 57 mb Access Database. I need this machine to run for a short time(less than a month), and then it will be imported into an SQL format. But when ever I have at least 10 users on this share with the login of "guest", I am then unable to have any more users login. It seems that W2k Professional can only support 10 concurrent users per share.
Any help would be appreciated.

2 replies

by bklein

10 Users is about the max an Access database will support. Winnt 5 (workstation, I assume) would still allow 24 concurrent users per share.

Moving to Winnt 5 SERVER will allow 64 users per share and migrating to SQL should eliminate ODBC jams.

by infra_hdc

In older versions of Windows where is the same limitation, thus WinNT 4.0 Workstation supports of maximum 10 connections per server too. Try to use a server oriented W2K edition, such as Server or Enterprise.

This discussion is closed to new replies.