Front End/Back End & Locking issues

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MelanieZ - 31 Oct 2007 00:22 GMT

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?

Reply to this Message

Tony Toews [MVP] - 31 Oct 2007 02:11 GMT

>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

Signature

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/

Reply to this Message

John Nurick - 31 Oct 2007 07:50 GMT

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.

>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?

--
John Nurick - Access MVP

Reply to this Message