Full Version: maximum users with mde
UtterAccess Discussion Forums > Microsoft® Access > Access Q and A
tonydotigr
I have an mde that links all its tables from another database, so all tables are linked. What is the maximum amount of users that can connect/open this mde? TIA
dannyseager
Your Backend is a MDE? there's no real point in that as there should be no code in there.

Techinically 255 Users. Realistically 20 - 30.

It all depends on how normalised and how well your relationships are setup
tonydotigr
No, the backend is just a normal mdb with tables. MDE links to those tables.
dannyseager
ok. Well the numbers I posted still stand.

If you need more concurrant users then you might consider upgrading to a MySQL or Microsoft SQL server Back end.
tonydotigr
Thanks Dan!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.