I have deployed few Access apps splitting it in Front End and Back
End. Our environment uses Win XP SP2 for clients, Win 2k3 for servers
and Access 2003. The max. number of clients is about 50 (concurrent
users is estimated around 10).

Whilst the Back End always lives on a server, I am not quite clear
where the Front End should live.

I have searched the web and find contradicting views.

Common sense tells me that if I have the Front End in the server then
maintenance should be a breeze because you maintain all your forms,
VBA codes, libraries, options, etc in just one place - but I am not
quite clear about *what* Access features are managed on the server and
*what* are managed (and dependent) on the workstation's install of
Access.

But it *seems* that in a shared environment it is better to have each
client with a copy of the Front End installed at their workstations
because the LDB file that contains the locking information seems to
work better - and this would be high maintenance because there are ~50
clients to maintain.

Is this correct? Will I have less chance of trouble with LDB files if
I have the Front End living on client's workstations as opposed to
having the Front End living on a server and being accessed by multiple
clients?

What would be best practice in a shared environment for a split MDB?
To have the Front End being accessed directly on the server or to
install the Front End on each client's workstation?

Sorry - This seems not to be the right place to post this; I re-posted
this on the Access group