MS Access Concurrent Users

[gator9]

Hey guys:

I have a database built in ms access, and was wondering what the realistic limit on concurrent users was? By concurrent users I mean, on the database, working and entering data at the same time. Microsoft says 255 but I know it must be much lower, and everything I have read says around 25. Can anyone give me an Idea?

Sincerely,

Charles

http://gator9.com

 

[Ed2020]

It really depends on how the database has been designed and what kind of network you have.

Is the database split into a frontend and a backend?
If so, does each user have their own frontend?
How have you designed your forms? Bound or unbound?
What kind of data volumes are there? How many records, how many tables?
How is data entered into the system?
Will users be running lots of queries against the data?

Ed Metcalfe.

Please do not feed the trolls.....

 

[Troyston]

As a rough guide 10 used to be a realistic number of users, however, feelings may have changed.

Troy Vinson
Trading as IT Supportman

http://www.itsupportman.co.uk

 

[Ed2020]

I have developed large and complex databases that have been perfectly happy with 80+ concurrent users.

It all depends on how you design it.

Ed Metcalfe.

Please do not feed the trolls.....

 

[gator9]

The forms are bound and connected via a no dup ID and yes there is a front end and two back ends. One backend is current records and the second is an archive where the data is transferred when the account paid out.

We have a switchboard an all users have there on permissions but all see the same switch board. We have around 1800 records, and data is entered in via a data entry form bound t a particular client.

Sincerely,

Charles

http://grahamenterprises.net

 

[Ed2020]

Bound forms don't help the concurrency issue, but with the data quantities you are talking about I wouldn't expect any problems with 25+ users in the database. You could probably push it to almost double that.

Reading between the lines it sounds like most users are simply manually entering records, not querying large recordsets. Assuming you have a decent network bandwidth (Access is extremely bandwidth hungry) you shouldn't have any worries at all.

Ed Metcalfe.

Please do not feed the trolls.....

 

[gator9]

Thanks for the information.

Sincerely,

Charles

http://grahamenterprises.net