Multiple Users Using SQL

J

Jafranklin2

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.
 
N

Norman Yuan

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.
 
A

Albert D. Kallal

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...
 
A

aaron.kempf

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
 
C

Candance

Well, which is it? Can 1000s of users be on at the same time, or only one on
the front end at one time?
 
L

Larry Linson

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
 
Top