Front End/Back End & Locking issues

[Guest]

Hi There;

Wondering when splitting a database, what is the maximum number of
front-ends you can have per database? The way I figure, I need to have about
25 front-ends and wondering if that is just crazy? If so, what would you
recommend to use instead?

 

[Tony Toews [MVP]]

Wondering when splitting a database, what is the maximum number of
front-ends you can have per database? The way I figure, I need to have about
25 front-ends and wondering if that is just crazy? If so, what would you
recommend to use instead?

25 FE's? Each identical but for 25 users? You can have up to 255
users in an Access BE MDB but that's probably pushing things a lot.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John Nurick]

Hi Melanie,

Do you mean multiple users each with a copy of the same front end (in
which case see Tony's response) or multiple front ends each providing
different functionality against the same back end database?

If the latter, you can think of them as multiple applications which
use a common data store. There's no limit on the number you can have
except (a) your imagination, (b) the difficulty of maintaining them,
and (c) the number of simultaneous connections (one user with two
front ends open at the same time is two connections), which takes you
back to what Tony said.