Max Number of Users in Access

[Grant Hachmann]

We have a network application that is constantly freezing
and locking users out of records. Database compaction &
repair works for a little while but the database is only
160MB. Is there a recommended maximum number of users
accessing the application, and can than number be
increased. I see where I can change the MAXLOCKFILE and
could this be the answer?

 

[Arvin Meyer]

There are a lot of reasons this could happen. One machine could have a bad
video card or driver and lock up the system on that machine. There could be
a bad NIC on a switch or hub.

The usual reason, however, if there are too many locks is that the
application was designed without proper indexing, or that if there is good
indexing, it isn't being used optimally. A good rule of thumb is that you
never need to call all the records in any table at one time, because you
can't use them all at one time.

The "official" number of users is 255. In practice, it is far lower than
that. The general recommendation is 20 users. I have several applications
comfortably using concurrent 40 to 50 users.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access