Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

News      User Comments     History     Notify Me

9/9/2008 2:37:49 PM
Max Users for a Microsoft Access Database
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
Q: Richard, I read a users question and your answer regarding multi-user Access front end and sql server backend combination. i have two specific questions:

a)  is there a practical / theoritical limit to how many number of users can connect simultaenously to the access front end which is connected to sql server backend using linked tables ?

b)  As the number of users increase, is there a changes of the mdb file getting corrupted ?

Thank you.
Sanjay Shah




A: Assuming JUST an Access database without a SQL Server backend...

I don't know if there is a PHYSICAL limit. As far as as PRACTICAL limit, assuming a normal 100 mbit network speed and a decent server, I wouldn't have more than 10 to 15 users on JUST an Access database, but there are exceptions (see below).

The chance always increases with more traffic - but the main problem is just speed. As more and more users hit the MDB file, it's going to slow way down.

Access wasn't designed for a LOT of traffic. Now, you could have only 5 users on the database that are asking for TONS and tons of records (lots of updates, reads, etc.) and they might bog the database down... but on the other hand, you could have 50 users on the database that are only occasionally looking up a record and maybe changing things once in a while - and be totally fine.

So it's really more of a matter of THROUGHPUT and activity than it is simply the number of users.

My suggestion is to simply TRY IT and see how your speed is. Once you start noticing it bog down, then you might want to consider upscaling it to SQL Server.

Now, once you bring the SQL Server backend into the equation it's really not a problem at all. Your Access front-end should be located on each user's PC. Yes, you could have them all hitting a shared one, but I don't recommend it. Then, SQL Server is handing out the data - so the performance is going to be as good as it gets.

Permanent Link
Keywords: access tips maximum users
Post Reply

Add Your Comments or Subscribe
 
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 2+6:
  
  Notify me when the News is updated.
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

You may want to read these articles from the 599CD News:

3/26/2020Sorted Combo Box Values
3/23/2020Browsing and Selecting Files
3/14/2020New Access Group
3/6/2020NEW Access 2019 for Beginners
8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP