Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / May 2004

Tip: Looking for answers? Try searching our database.

Maximum amount of concurrent users on Access 2000 Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
marko - 13 May 2004 16:09 GMT
Can someone please give me the definative answer on what
the maximum number of concurrent users connecting to a MS
Access (2000) security database.

oportunistic locking seems to be the likely candidate,
however if this is turned off it is likely to affect
other databases which do not experience the problem.

thanks

marko
Rick B - 13 May 2004 17:22 GMT
Type "specifications" in help and then click on "General Specifications"
you will find that Access 2000 allows 255 concurrent users.

Can someone please give me the definative answer on what
the maximum number of concurrent users connecting to a MS
Access (2000) security database.

oportunistic locking seems to be the likely candidate,
however if this is turned off it is likely to affect
other databases which do not experience the problem.

thanks

marko
Tony Toews - 13 May 2004 22:06 GMT
>Can someone please give me the definative answer on what
>the maximum number of concurrent users connecting to a MS
>Access (2000) security database.

I have a client running 25 users with next to no problems.  There are
reports of folks running 100 users.

>oportunistic locking seems to be the likely candidate,
>however if this is turned off it is likely to affect
>other databases which do not experience the problem.

I've actually never mucked with this setting so I'm not sure of all
the ramifications.

Tony
--
Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
david epsom dot com dot au - 14 May 2004 02:16 GMT
> Can someone please give me the definative answer on what

No....

You should be able to put the security database in a read
only folder, and allow unlimited access.

In my experience, opening an MDB and making Design Changes
may lock the security database, making it unusable until
that copy of Access is closed, releasing the security database
locks.

Try putting the security database in a read-only location:
If you make design changes, use a private copy of the security
database:
If possible, distribute private copies of the security database
to the users (update as required).

(david)

> Can someone please give me the definative answer on what
> the maximum number of concurrent users connecting to a MS
[quoted text clipped - 7 lines]
>
> marko
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.