How many users can access a database simultaneously?

[gabry.morelli]

Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo

 

[Joseph Meehan]

Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo

255 is the official number. While there are variables I would suggest
that over about 25 is likely to be a problem. Some people have reported
problems with smaller numbers. Likely it depends on database design and the
quality of the network.

 

[aaron.kempf]

Daniel

that is ****ing hilarious.

Access _MDB_ cannot be used across a WAN.

Access _ADP_ works across WAN, VPN, Wireless, etc.

MDB is for lamers and ****ing retards; and it can't realistically
reliably support more than a half dozen users

-Aaron

 

[Joseph Meehan]

that is ****ing hilarious.

Access _MDB_ cannot be used across a WAN.

Access _ADP_ works across WAN, VPN, Wireless, etc.

MDB is for lamers and ****ing retards; and it can't realistically
reliably support more than a half dozen users

-Aaron

Please ignore the fact that aaron said it. In this case ADP may be the
better tool.

 

[aaron.kempf]

since

a) ADP are easier development
b) ADP have much superior management tools (SQLAgent? )
c) ADP have much better analytical tools (Analysis Services)

then

all databases should be written in ADP instead of MDB

because

a) you can't always forecast the needs of a database. build it right or
build it twice
b) ADP is easier development
c) training resources for SQL are tenfold training resources for REAL
mdb development

 

[Joseph Meehan]

since

Has anyone ever figured out why Aaron hangs out around here? What
possible good does it do him?

 

[Guest]

A split database (front end/back end) can technically have up to 255 users.
Most users experience problems with any more than 25 and some users have
problems with 10. A lot has to do with the database design and how you
retrieve information from the back end.

If you need to have more than a dozen or so users, then you can always look
at the option of using Sql. You can even use a combination of Sql and Access.

 

[aaron.kempf]

hey buddy just because I talk shit that doesn't mean that I am not the
#1 fan of Microsoft Access.

I just think that your crappy little MDB files are quaint and I laugh
at you when I see you troubleshooting file problems and dealing with
permissions in 3 different places

-Aaron