Limitations to How Many Users can use the same form at the same ti

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Afternoon Everyone,

I have a question in relation to Limitations for a Database. We are working
on a new project that involves about 300 people using the same Standard
Created Form to populate information in an Access Database all at the same
time, is this possible or would it better to use something else?

Any suggestions or information would be greatly appreciated...

Thank you in advance,

Mike
 
Mike

You have 300 people all trying to crowd through a single doorway at the same
time? <g>

The standard "split" design calls for one set of data on the backend/server,
and one copy of the front-end per each user, on each user's PC.

You will find a theoretical limit of 255 simultaneous users, below your 300
figure. How many of your 300 are on the same LAN?

If you really do need to have 300 simultaneous users, consider using SQL
Server or some other more robust database engine for your backend.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a question in relation to Limitations for a Database. We are
working
on a new project that involves about 300 people using the same Standard
Created Form to populate information in an Access Database all at the same
time, is this possible
Click to expand...
Well, 300 people means that you would have to install your application 300
times. You also don't mention what kind of IT support people you have, or
what kind of servers you have.

If you are in a corporate IT environment, and each machine is versioned, and
they are all the EXACT same image, then deploying your application to 300
users would not be much of a problem. of course, for the data part, you
would use sql server.

So, much of your ability to do this, and accomplish this is going to depend
on how much you have over the control of the target computers.

You can use ms-access with 300, or even 600 people all at the same time.
(there are people out there with systems that have a 1000 users using the
sample application at the same time (of course, the front end is installed
on each computer). However, while the front end can be ms-access, for a such
a large user count, the back end will be a database server, such as sql
server.

The problem you have is not the number of users, but issues of do they have
ms-access installed, are they the same version. (in fact, even if they are
at different service pack (sp) release levels can cause problems.

so, your problems and solutions will center around the computer
infrastructure you have. You don't want one problem to be multiplied by 300
times...as that will kill your support budget.
or would it better to use something else?
Click to expand...

From the information you given, it hard to tell. Perhaps a web based system
would be better here?
 
Back
Top