Multiple Users

[Guest]

Hello,

We were wondering about the multiple user accesses. Basically all the users
are only going to update or add additional data to the records.

For one how many users can a database hold?
Is there any better way to house the database instead of giving them access
to the database with built in security rights?

What is the best way to go about this process?
- about 25 to 30 users
- an access database file stored on a local server
- everyone will have access to only the forms where the can enter data and
reports to veiw the reports.


If any other suggestions, would be helpful thanks.

 

[Jeff Boyce]

Lee

Take a look in Access HELP, at mvps.org/access, and in the .tablesdbdesign
newsgroup on the topic of "splitting" a database. Whether or not you use
Access to hold the data, with multiple users you will want to have a single
source of data, and each user needs to have his/her own copy of a
"front-end" (i.e. client).

If you intend to use Access' built-in security, make plenty of backups and
spend some serious effort learning how to use it ... it isn't "cheap".

Access databases don't "hold" users. There's a theoretical limit of 250+
users, but the practical limit is around the number you are asking about.
But it depends on a lot of factors, such as speed/horsepower of the PCs, the
network and the server, load, number of users doing simultaneous data entry
(vs. only looking up info). Wireless LAN connections and WAN connections
are problematic

And if Access as a back-end data repository doesn't have the horsepower you
need, there are many other back-end databases that are more robust -- you
could still use an Access front-end to get at the data.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor