--- description: While theoretically Access can support 255 simultaneous connections, in reality, bottlenecks arise at even 20 to 25 simultaneous users. In this article, we plan the deployment in a manner than 100 users can be simultaneously supported. title: How to Design an Access Application that Can Sustain 100 Simultaneous Users image: https://www.datanumen.com/blogs/wp-content/uploads/2019/02/access-application-sustain-100-simultaneous-users.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Access Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/access-solutions/) > How to Design an Access Application that Can Sustain 100 Simultaneous Users # How to Design an Access Application that Can Sustain 100 Simultaneous Users [Access Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/access-solutions/) September 28, 2025 Share Now: - - - - - - - - *While theoretically Access can support 255 simultaneous connections, in reality, bottlenecks arise at even 20 to 25 simultaneous users. In this article, we plan the deployment in a manner than 100 users can be simultaneously supported.* Many small businesses tend to grow over time both in business size and employee count. With Access being the preferred database for small business users, there are numerous cases where people using Access in their company suddenly found that their line of business application needs to handle numerous users at the same time. While some experts suggest dumping Access altogether if you have, say 50 to 100 simultaneous users, the choice may be difficult for small businesses. Creating another application from scratch that too with a different database platform can prove costly. In such scenarios, you should look at using MS Access in an optimal manner and a well-designed Access application can even handle 200 simultaneous users at one time. Just follow the roadmap below to ensure your Access application can handle multiple users at the same time ![Design an Access Application that Can Sustain 100 Simultaneous Users](https://www.datanumen.com/blogs/wp-content/uploads/2019/02/access-application-sustain-100-simultaneous-users.jpg) 1.      **Split the Access Database and use privileges to restrict write access.** If you are looking to support numerous users, it is quite likely that you are using a split access database. In case you have not, immediately split the database with the front end user interface being deployed on user machines while the backend data repository been kept on a different machine. In case you need help on how to split your Access application, try visiting Microsoft’s support site.  In split database model, use user privileges to grant writing authority to a limited number of users while allowing read authority for all else. Not everyone in your office may need to input data and thus you can limit these people to view access only.  2.      **Design effective input forms and use proper validations** The amount of data that moves during concurrent sessions can affect the performance of an Access application. Ensure the input forms are well designed and do not contain useless data fields. If possible avoid attachment options in input forms.   3.      **Restrict size of graphics** In case you are using images, especially inputting image files, make sure you restrict their size. 4.      **Enforce correct Record locking options** In a multiuser Access solution, it is critical to choose the right record locking option. Choose the default open mode as Shared while you need to record locking default to Edited Record.  To access these options visit the File Menu and go to the Client Settings in the Options tab. 5.      **Adhere to standard Access optimization best practices** To ensure the application works perfectly, standard Access best practices need to be followed. They include the use of temporary tables wherever needed, smaller indexes and regular compacting of the backend database. ## **Prepare for Contingencies** When your application is being used by several users at any point in time, chances of errors and database crash is always present. Despite your best efforts, you may not be able to prevent an MS Access crash. To avoid incidents of data loss due to  [corrupt accdb](https://www.datanumen.com/access-repair/) or mdb errors, consider keeping an Access recovery tool like DataNumen Access Repair handy. ## **Author Introduction:** Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including  [sql fix](https://www.datanumen.com/sql-recovery/) and excel recovery software products. For more information visit  [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/outlook-rule-clear-categories-on-mail-will-block-all-incoming-emails/) [Next post →](https://www.datanumen.com/blogs/4-salient-differences-between-heap-tables-and-clustered-tables-in-sql-server/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Design an Access Application that Can Sustain 100 Simultaneous Users","datePublished":"2019-02-23T01:43:10+00:00","dateModified":"2025-09-28T14:06:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/"},"wordCount":599,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/access-application-sustain-100-simultaneous-users.jpg","articleSection":["Access Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/","url":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/","name":"How to Design an Access Application that Can Sustain 100 Simultaneous Users","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/access-application-sustain-100-simultaneous-users.jpg","datePublished":"2019-02-23T01:43:10+00:00","dateModified":"2025-09-28T14:06:47+00:00","description":"While theoretically Access can support 255 simultaneous connections, in reality, bottlenecks arise at even 20 to 25 simultaneous users. In this article, we plan the deployment in a manner than 100 users can be simultaneously supported.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-design-an-access-application-that-can-sustain-100-simultaneous-users\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/access-application-sustain-100-simultaneous-users.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/access-application-sustain-100-simultaneous-users.jpg","width":744,"height":458,"caption":"Design an Access Application that Can Sustain 100 Simultaneous Users"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```