Jet Engine

[Argovian]

I have just designed a Student report DBMS using ACCESS 2002. There will be
a total of 50 users and probably about 20 users working on various forms at
the same time. I have read in a few books that the Microsoft Jet database
Engine is unable to cope with more than 20 users - is this 20 users in total
or at the same time or?? I need some up-to-date info quick!

 

[MikeC]

Since you are asking for a quick answer, I'll share with you what I remember
from a KB article I read some time ago. The Jet 4 database engine can
support about 25-40 *concurrent* users (of a BE/FE application) if the back
end is on a file server. How many users the Jet 4 engine can handle largely
depends on how hard they are making the engine work. i.e. Are the users
just viewing? Making a few edits? Heavy data entry? Also, the workload of
the file server is another factor.

 

[Argovian]

Thanks for the help - there will be at least 10 users inputting information
into a student form at one time. I have put security measures - only one
person can work on one form at any one time; when a user click the back to
main button, it first saves the form, then close the form and then open the
main menu form. I sure hope it will work properly when I put it out for beta
testing next week!! Wish me luck.

Ann

 

[Marshall Barton]

This totally depends on what the users are doing and how
good a job you've done in designing your application. There
are reports of Access programs with over a hundred users. A
simple data entry form bound to a single data table can
update the data faster than the users can type the data.
OTOH, If you have numerous subforms, a lot of dependent
combo boxes and are constantly looking up related values,
then you may actually be able to put a significant load on
your network resources.