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

Tech-Archive recommends: Speed Up your PC by fixing your registry



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

"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E355CF19-14E9-4DEF-93DB-44DFD49298A0@xxxxxxxxxxxxxxxx
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


.



Relevant Pages

  • Re: GEDOM as a database format
    ... Tony Proctor wrote: ... isn't complicated Peter, but that doesn't make it impossible, and it doesn't ... It also includes the operating system crashing for no apparent reason and also the disk on which your database resides going up the swanee. ... The standard I want to see is something not constrained by application program, operating system, or hardware and even at a pinch be implementatble as a paper-based manual system. ...
    (soc.genealogy.computing)
  • Re: Some free utilities for Java, with Hebrew support.
    ... a third-party MySQL client library that I know of. ... market at large. ... The JDBC and ODBC models are such that the database vendor ... provides exactly that adapter to fill in a standard API. ...
    (comp.lang.java.programmer)
  • Re: Application Speed Problem - VERY weird
    ... MDE front ends not MDB ... If the DB is reading in a lot of records, ... The data is linked with the standard Access "link ... add that we have only ever used the database on Access 2K. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: META: how-to ruin a perfectly good FGS
    ... search engine is friendlier to special characters. ... It is again impossible to search for the "standard". ... I have no interest in submitting my database to such destinations. ...
    (soc.genealogy.methods)
  • Re: Good Books on MultiValue Databases
    ... have to admit I was intrigued by the multivalue database, however, I ... new languages very quickly, however AQL has so many non standard ... has a standard interface and can be normalized. ... This bypasses all the protections you would expect in a normal DBMS ...
    (comp.databases.pick)