locked
How many concurrent users (read) I can have when using Access on ASP.net ? RRS feed

  • Question

  • User-775831949 posted

    How many concurrent users (read) I can have when using Access on ASP.net ?

    meaning I have access file and there is a Gridview drawing the data from it to the web.

    How many users can view the data at the same time if I am using

    (1) mdb

    (2) accdb

    Apart from size limit, what is the extra benefit in using accdb ?

    Thursday, June 8, 2017 8:43 AM

Answers

  • User-1509636757 posted

    Microsoft has stated that Access is able to support 255 concurrent users, it is a more practical choice to select Access when the database will be used by only 15 to 20 simultaneous users. If more than 20 users try to gain access to the database, performance and response time may begin to suffer.

    Here is the referenced article: Disadvantages of Microsoft Access | SQL Programmers

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 9, 2017 6:35 AM
  • User-1838255255 posted

    Hi hkbeer,

    According to your description, as far as I know, the concurrent users limitation of the Access database is 255, for more details, please refer to the following official document of access: 

    Access 2016 specifications:  

    https://support.office.com/en-us/article/Access-2016-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

    Also you could check the following tutorial about the advantage and disadvantage of MS Access and MS SQL Server, please check:

    Microsoft Access Versus SQL Server:

    https://www.quackit.com/microsoft_access/tutorial/microsoft_access_versus_sql_server.cfm

    If the number of visitors of your website is huge, I think SQL Server is good choice.

    Best Regards,

    Eric Du

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 9, 2017 7:08 AM
  • User991499041 posted

    Hi hkbeer,

    How many users can view the data at the same time if I am using

    (1) mdb

    (2) accdb

    Apart from size limit, what is the extra benefit in using accdb ?

    Access can theoretically support 255 concurrent users,

    ACCDB FILE FORMAT BENEFITS

    • Include attachments in your database. 
    • Use multivalued fields.
    • Safe integration with SharePoint and Outlook.
    • Encryption improvements.

    Regards,

    zxj

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 9, 2017 7:16 AM

All replies

  • User-1509636757 posted

    Microsoft has stated that Access is able to support 255 concurrent users, it is a more practical choice to select Access when the database will be used by only 15 to 20 simultaneous users. If more than 20 users try to gain access to the database, performance and response time may begin to suffer.

    Here is the referenced article: Disadvantages of Microsoft Access | SQL Programmers

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 9, 2017 6:35 AM
  • User-1838255255 posted

    Hi hkbeer,

    According to your description, as far as I know, the concurrent users limitation of the Access database is 255, for more details, please refer to the following official document of access: 

    Access 2016 specifications:  

    https://support.office.com/en-us/article/Access-2016-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

    Also you could check the following tutorial about the advantage and disadvantage of MS Access and MS SQL Server, please check:

    Microsoft Access Versus SQL Server:

    https://www.quackit.com/microsoft_access/tutorial/microsoft_access_versus_sql_server.cfm

    If the number of visitors of your website is huge, I think SQL Server is good choice.

    Best Regards,

    Eric Du

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 9, 2017 7:08 AM
  • User991499041 posted

    Hi hkbeer,

    How many users can view the data at the same time if I am using

    (1) mdb

    (2) accdb

    Apart from size limit, what is the extra benefit in using accdb ?

    Access can theoretically support 255 concurrent users,

    ACCDB FILE FORMAT BENEFITS

    • Include attachments in your database. 
    • Use multivalued fields.
    • Safe integration with SharePoint and Outlook.
    • Encryption improvements.

    Regards,

    zxj

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 9, 2017 7:16 AM