No. of Users and Data Security
How many users can use the access database simultaneously and what about the
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.
--Show quoteHide quote
MS Access MVP
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
"Neal" <Nemail@example.com> wrote in message
> How many users can use the access database simultaneously and what about
> data security?
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!
TC [MVP Access]
Other interesting topics
Self Modifying Code, Digital Certificates
Replication ***PLEASE HELP***
Issues after splitting database
ms access username password issue
What MS Access version to use?
/wrkgrp switch won't work
Replication & Security
MDW file - what am I doing wrong?
Access 2000 Security
Linking a unsecured database to a table in a secure database