Access Limit

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a program on the office network which can be accessed by 10 users
similtatiously, I have now created another Access form which is Linked to
the main one & could also be used by a further 15 people. Is there a
potential problem here?

Bruce
 
I have a program on the office network which can be accessed by 10 users
similtatiously, I have now created another Access form which is Linked to
the main one & could also be used by a further 15 people. Is there a
potential problem here?

Bruce
Click to expand...

You are officially limited to 255 concurrent users; but in practice
I'd get a bit queasy with 25 users *if* they're all updating the
tables. If they're just reading (or most of them are) you should be
fine.

DO split the database. If you have 25 (or even 5) users sharing the
same .mdb file you're cruising for trouble. See

http://www.granite.ab.ca/access/splitapp/index.htm

The "split" architecture has all of the tables in a single shared
database; each user will have their own copy of a "frontend" database
containing the forms, reports, queries etc., with the tables linked.
 
Back
Top