Multiple Users Using SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have designed a application with a SQL connection (Access Project),
my question is how many multiple (at same time) user can use the application
with this set up.
 
As many as the back end SQL Server can take. For a SQL Server (Standard
editon or Enterprise Edition) to have dozens or hundreds concurrent
connections, depending on the available resources (CPU, Memory, OS...),
Also, the bad/good application designs could play a big role.
 
I had reports of up to 1000 users with your type of setup (mind you, the sql
server side was rather top of the line).

do remember, that each user gets a copy of the front end adp, and do NOT
allow more then one user into that front end at the same time...
 
Albert;

so if you've had soo many users on an ADP why in the HELL are you a MDB
pussy?
so if you've had soo many users on an ADP why in the HELL are you a MDB
pussy?
so if you've had soo many users on an ADP why in the HELL are you a MDB
pussy?
so if you've had soo many users on an ADP why in the HELL are you a MDB
pussy?


-Aaron
 
Well, which is it? Can 1000s of users be on at the same time, or only one on
the front end at one time?
 
Each user should have his/her own copy of the front end... so one user per
front-end copy.

But many, many front-ends can be concurrently attached to SQL Server (thus
many, many users).

Larry Linson
Microsoft Office Access MVP
 
Back
Top