Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Nuber of users

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Boss - 18 Jan 2008 14:06 GMT
I wish to prepare a shared database with 120 users. All user would feed in
data in therie respective forms.
The question in my mind is would the databse get hanged? or it would allow
all users to feed in data simuntaneously.
I am thinking of splitting the data to reduce traffic.

Thanks for the help
Boss
Arvin Meyer [MVP] - 18 Jan 2008 14:18 GMT
Access statistics have a maximum user count of 255 on a Jet back-end
database. I've used up to approximately 75 concurrent users, but many of
them were reading, not writing. I seriously doubt that you can have that
many users without having some corruption problems. OTOH, you should be able
to have that many Access front-end users on a SQL-Server back-end without
any difficulty.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I wish to prepare a shared database with 120 users. All user would feed in
> data in therie respective forms.
[quoted text clipped - 4 lines]
> Thanks for the help
> Boss
Boss - 18 Jan 2008 14:30 GMT
Thanks of the info..
It helped me alot..

Thanks
Boss

> Access statistics have a maximum user count of 255 on a Jet back-end
> database. I've used up to approximately 75 concurrent users, but many of
[quoted text clipped - 10 lines]
> > Thanks for the help
> > Boss
Dale Fye - 18 Jan 2008 14:58 GMT
When you say "splitting the data", do you mean creating separating the data
from the application?  If so, this is a must for any multi-user Access
appliction.  NEVER allow multiple users to use the same mdb file sitting on a
network.  They should all have identical front ends and all point to (have
tables linked) from the backend (data) sitting on your server.

As Arvin stated, you should probably check into SQL Server Express (if you
don't expect and individual database to exceed 4 Gig), because it is free for
download.  If you expect your data to exceed that, you could probably segment
the data into separate SQL Server "databases" and still link to those in
Access, I just don't know how efficient it will be to create queries that use
tables from multiple SQL Server "databases".  The other option is to step up
to SQL Server or go to an Open source database like MySQL.

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> I wish to prepare a shared database with 120 users. All user would feed in
> data in therie respective forms.
[quoted text clipped - 4 lines]
> Thanks for the help
> Boss
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.