Simultaneous user

[ORJAN]

Hi,
Is there a limit as to how many users that could
have access an Access database application at the
same time?
The application consists of one object database
(forms, reports code etc) and one database that
contains only the tables with some 50.000 items.
Best regards

 

[Rick Brandt]

Hi,
Is there a limit as to how many users that could
have access an Access database application at the
same time?
The application consists of one object database
(forms, reports code etc) and one database that
contains only the tables with some 50.000 items.
Best regards

The technical "hard" limit is 255. The actual practical limit depends on
the app, your network, and what the users are doing (reading versus
writing). Well designed mostly read apps can exceed 100 users. For
write-intensive apps 20-50 is more reasonable.

 

[Tom Wickerath]

To add some to Rick's answer, see my Multiuser applications paper here, for
helpful hints:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________