No. of Users and Data Security

[Neal]

Help

How many users can use the access database simultaneously and what about the
data security?

 

[Lynn Trapp]

The system allowed maximum number of concurrent users is 255, although in
practical terms the number is probably more like 50. I worked at a place one
time that had around 60 concurrent users, but the database suffered from
frequent corruption problems.

Data security in Access is problematic. Because Access is a file system
database, it's possible for a knowledgeable person to copy the file and/or
export the data. A combination of network security and Access user level
security can provide a fair amount of deterrent to most people. If you need
your data to be more secure than that, then you need to put it in a server
level database such as SQL Server or Oracle.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[TC]

How long is a piece of string?

If the database is structured correctly, and the code is written well,
and all the users are doing queries (not updates), and the network is
fast and reliable, Access can probably handle "in the order of" its
specified maximum number of simultaneous users.

Conversely, if the database is not structured correctly, or the code is
written badly, or most of the users are doing updates (not queries), or
the network is slow or unreliable, then, Access might expire with a
very small number of users.

Pay your money and take your choice!

HTH,
TC [MVP Access]