6 user limit

W

Wayne

Hi,
I have a form built on a workstation (XP) for data entry
into an access database. When we go out to a remote site
we are all connected together on a wireless LAN, about 10
laptops all running XP. We all need to get to the form and
enter data, but there is a 6 user limit, when #7 gets on
it kicks off one of the existing connections. Is this an
MS Access limit on the form somewhere or a workstation
limit? I thought I could have ten connections at the
workstation level.
Thanks - Wayne
 
D

Dirk Goldgar

Wayne said:
Hi,
I have a form built on a workstation (XP) for data entry
into an access database. When we go out to a remote site
we are all connected together on a wireless LAN, about 10
laptops all running XP. We all need to get to the form and
enter data, but there is a 6 user limit, when #7 gets on
it kicks off one of the existing connections. Is this an
MS Access limit on the form somewhere or a workstation
limit? I thought I could have ten connections at the
workstation level.
Thanks - Wayne
Click to expand...

I'm no networking expert, but I'm guessing this is imposed by your LAN
or your version of the OS. Access doesn't impose such a low limit.

But how solid is your wireless LAN? Access is pretty sensitive to shaky
networks. Also, are you sharing a single, unsplit database over the
LAN? If so, I have to say that is not a good idea. The best way is to
split the database into a back-end (containing just the tables) and a
front-end (containing everything else, with tables linked to the
back-end). Then each user is given a copy of the front-end. This
reduces traffic over the network and the chance of database corruption
if the network isnt rock solid.
 
W

Wayne

-----Original Message-----


I'm no networking expert, but I'm guessing this is imposed by your LAN
or your version of the OS. Access doesn't impose such a low limit.

But how solid is your wireless LAN? Access is pretty sensitive to shaky
networks. Also, are you sharing a single, unsplit database over the
LAN? If so, I have to say that is not a good idea. The best way is to
split the database into a back-end (containing just the tables) and a
front-end (containing everything else, with tables linked to the
back-end). Then each user is given a copy of the front- end. This
reduces traffic over the network and the chance of database corruption
if the network isnt rock solid.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
Click to expand...
Thanks for the info - I will look ibto the networking side.
- Wayne
 
A

Arvin Meyer

Just to let you know, I have as many as 50 users connected at the same time,
some with multiple front-end applications to the same set of back-end
tables. The official limit is 255 users, but I would call that optimistic.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
L

Larry Linson

Sounds as if you have a peer-to-peer network. They allow a limited number of
connections to a given share and I suspect that is what you have
encountered.
 
Top