Question Is there a limit to the number of Users?

[matthewnsarah07]

I currently have a database in Access 2003 that I sue to collect staff holiday requests.

The back end is on the company server and then there are two front ends. One is for managers wishing to approve requests and the other for staff wishing to enter requests.

Like any database of this type the number of users wishing to gain access at anytime can be anything from 0 to around 20 and recently I was told by our IT dept that they experienced problems with Access if more than 5 people wanted simlutaneous access.

My Q's

1) Regarding my last comments, is this the case with access and multiple users?

2) Is there any way to improve an access database for larger number of users or is there a way to restrict the number using it at any one time?

Thanks for your help

 

[Rabbie]

If you have concurrent users it is a good idea to provide a FE for each one in order to reduce the risk of corruption.

If you have an Access FE for each user and a SQL server as BE then you should be able to support many more users concurrently.