Access Database Simultaneous Sign On

[Robert Donnelly]

I am placing a database I created on a Virtual Drive at my place of business.
How many people can safely sign onto an Access Database at the same time?

 

[John Vinson]

On Sun, 16 Apr 2006 12:34:01 -0700, Robert Donnelly <Robert

I am placing a database I created on a Virtual Drive at my place of business.
How many people can safely sign onto an Access Database at the same time?

Nominally 255, according to the specifications. In practice, 30 to 40
simultaneous updating users (or well over a hundred read-only) works
satisfactorily, depending on the design and proper implementation of
the database.

HOWEVER... I'd VERY strongly recommend using the Database Splitter
Wizard to split the database into a "backend" containing the tables,
and a frontend containing the user interface. Each user should have
their own copy of the frontend, all linked to the shared backend.

See http://www.granite.ab.ca/access/splitapp/index.htm for details
about splitting.

John W. Vinson[MVP]

 

[Minnow]

Hi John,

I splitted my databse. In my frontend, I produced lots of queries (based on
tables or queries or both) and reports. How can let other user view them?

Thanks.

 

[John Vinson]

Hi John,

I splitted my databse. In my frontend, I produced lots of queries (based on
tables or queries or both) and reports. How can let other user view them?

Each user should get their own copy of the frontend. They'll all be
linked to the data (which resides in the shared backend); forms,
reports, and queries don't contain any data on their own, they just
pull data from the (shared) Tables. See Tony's website for details
about how to set this up.

John W. Vinson[MVP]