Multiple users entering data

  • Thread starter Thread starter Annetta
  • Start date Start date
A

Annetta

I would like to build an Access database for multiple users to enter and
retrieve data. The database will be on a shared drive, but does Access
support multiple users possibly entering data at the same time? I’ve built
one for a smaller group (2-3 people), but there will be 20+ people using this
database.
 
I would like to build an Access database for multiple users to enter and
retrieve data. The database will be on a shared drive, but does Access
support multiple users possibly entering data at the same time? I’ve built
one for a smaller group (2-3 people), but there will be 20+ people using this
database.
Click to expand...

You're nominally limited to 255 concurrent users; in practice I'd be
uncomfortable with more than 50 or so concurrently updating users.

You should, however, split your database into a shared "backend" containing
the tables, and give each user a "frontend" containing your forms, queries,
reports, etc., each linked to the backend. Use Tools... Utilities... Database
Splitter Wizard to do this, and/or see
http://www.granite.ab.ca/access/splitapp.htm

for a discussion.
 
Back
Top