How many users can I support using an ADP?

[Artificer]

I know this question completely depend of the system on resources on
the SQL Server box but I want to know if somebody is using an
access .adp with a SQL Server Backend how many users is the
application supporting and the size of the database. If you can tell
me the server configuration I will appreciate it!

 

[Pat Hartman \(MVP\)]

If each user has his own copy of the .adp, the number of concurrent
connections is limited by the server. If .adp's work like .mdb's (I never
use .adp's) and they open an .ldb file when the application is opened, then
the limit is 255 concurrent users.

 

[Paul Shapiro]

Since the .adp is connecting to a SQL Server and not doing any data
management itself, no .ldb is created. The 255 user limit of an .mdb doesn't
apply to an .adp. But it's not just the server resources and db size either.
Application design has a huge impact. If you create forms that return all
rows from a table you will be able to support less users than if you're more
careful about minimizing the data you move and the number of roundtrips to
the server.
Paul Shapiro