Multiple users of access

  • Thread starter Thread starter Amin
  • Start date Start date
Officially, 255. I wouldn't try that many except in a read-only mode.

Some non Access database developers would be tempted to say 0 or 5 at most.
They know less about databases, and especially Access databases, than they
should. Most articles by Accrss developers use, the number 20, as a safe
number. I have had as many as 75 concurrent users in a well designed
database, without any problems whatsoever. I've heard of many more, but
can't verify that.
 
To create a multi-user MS Acccess database you need to split your database.
Once it is split (back-end housing the data & front-end housing the gui) you
would place the back-end on a central server and deploy/distribute a copy of
the front-end to each user so they install their own copy on their pc.

Also, typically, for deployment you would convert your mdb to an mde, or
accdb to an accde.

As Arvin stated, Access theorectically can support 250 users simultaneously.
If Arvin has managed cases of 70 user, then you know that it can be done!

What version of access are you working with?
What type of network are you working on?

Note, Access cannot be used over a wireless network!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Amin said:
if i create a database for a company how can it be asseed by many users in
the company.
Click to expand...

How many is many? Are these all in the same building? If many is
more than 20 or 30 consider keeping your data in SQL Server or
equivalent. Or if they are in other buildings with the WAN connection
at 10 mpbs or slower or via wireless then consider either SQL Server
or Terminal Server.

In the meantime you want to split the MDB into a Front End MDB
containing the queries, forms, reports, macros and modules with just
the tables and relationships in the Back End MDB. The FE is copied to
each network users computer. The FE MDB is linked to the tables in
the back end MDB which resides on a server. You make updates to the
FE MDB and distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
free Auto FE Updater utility at http://www.autofeupdater.com/ to make
the distribution of new FEs relatively painless.. The utility also
supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Amin said:
if i create a database for a company how can
it be asseed by many users in the company.
Click to expand...

I'm not sure what you are asking. If you mean, "Do I have to do anything
special to allow multiple users to access the database?" The answer is, "No,
Access is multi-user enabled out of the box."

That said, this is only going to work with "standard Access" on a LAN,
preferrably 100 MBPS or faster. And, it is going to work better if you split
the tables into a back-end database on the server and give each user a
front-end database with the user interface, linked to that back end.

Others have suggested the number of users it can support.

If you want to use it over a WAN, or over the Internet, those are different
situations. If you go with a client-server arrangement with Access and the
client, and MS SQL Server or other ODBC-compliant database as the back end,
then there is no practical limit on number of users... it will depend on the
number of concurrent connections your server and server DB will support.

Larry Linson
Microsoft Office Access MVP
 
Back
Top