Mozart said:
I have an MDB database access file that contains tables, quieries,
forms, and reports, and we need to make that file available for
multi-users to view/edit all the content information. Is this feature
available in Ms Access? Let me know please.
Thanks in advance
Access provides multi-user capabilty right out of the box. It is
possible to put an MDB file on a shared drive and have everyone with
access to that share (and with Access installed) work with it. However,
it is much better, and less prone to database corruption, to split the
database into a "back-end" (which contains just the tables) and a
"front-end" (containing everything else, with links to the tables in the
back-end). Then the back-end is placed on the server, and a separate
copy of the front-end is placed on each user's PC. The Database
Splitter wizard can split the database for you.
There is a theoretical maximum of 255 users connected to the database
simultaneously, but the practical limit is much lower than that.
Exactly how many simultaneous users is workable depends on what sort of
tasks the users are doing, and how well the database is designed. 20 or
30 is seldom a problem, as far as I've heard, and I imagine you could
have over a hundred read-only users if all curcumstances were just
right.
All users must have full permissions to the folder where the back-end
database resides.
