Curry said:
Rob, I'm a bit of a babe in the woods - I run a small business using
MS Access - I have one computer in a peer to peer network designated
as a "server", and a number of others that access the MSAcess
databases on it. Each "workstation" has a copy of MS Access, and the
in house database front end installed - they then access the required
data databases on the server. Until I added the 11th computer
everything was fine - but now the system
won't allow all computers access to the server at the same time. Is
there anyway I can set things up so that this problem can be overcome,
or do I need to move to a formal server with server type software to
allow the additional computer(s).
I'm not Rob but you are running into the inbound connections limitation.
This has nothing to do with the number of computers in the Workgroup.
The limitation is not on *computers* but *connections* and each
computer can make more than one connection to your pseudo-server.
If the pseudo-server is simply acting as a file server (not actively
running Windows programs), you could replace it with a Linux operating
system which does not have the inbound connection limitation. If you
are running Windows programs and/or don't have the support you would
need for Linux then you need to install a Microsoft server operating
system and set up a domain. You will have all the benefits of more
security, centralized management of workstations, and centralized data
backup (if you aren't doing that already). Small Business Server would
suit your needs admirably. All workstations need to be running XP Pro
to be members of the domain.
Here is information about the inbound connections limit:
http://support.microsoft.com/?id=314882
concurrent connections:
10 for XP Pro/Tablet/MCE
5 for XP Home
49 for SBS 2000
74 for SBS 2003
Unlimited for full Server O/Ses
Malke