Share via

MS Access 2019 Concurrent User Limitation Question

Anonymous
2021-07-29T14:26:57+00:00

We have an Access 2007 project that we are in the process of migrating to 2019. This existing project already uses SQL Server on the back-end and Access as a front-end only. Currently each user gets their own ADE file (ACCDE under the new version).

My question revolves around the 255 user limitation in Access 2019. If each user has their own ACCDE file, does that 255 concurrent user issue still come into play with how we are distributing the front-end application? If it does, could you please explain how and why that limitation would be imposed?

Thank you,

DHT.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-07-29T14:34:42+00:00

    255 is the (theoretical) maximum number of simultaneous users of a single Access database.

    Since each of your users has their own copy of the front-end, and since the back-end is not an Access database but a SQL Server database, the 255 user limit does not apply to your setup.

    SQL Server has a limit of 32,767 simultaneous connections.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-07-29T16:05:31+00:00

    Thanks so much for your prompt reply.

    0 comments