What front-end / back-end setup is best?

On a network with about 10 users, Access 2000 databases, XP Pro, what is the best way to
set up front-ends and back-ends?
Should every user have a front-end on his PC or should everyone have a shortcut to
one front-end? Or should each user have a shortcut to a seperate replica of the front-end?

I thought replicas were only useful for synchronizing back-ends.

I'm surprised to walk in to a job and see different setups and I wonder if there
is any reason that these have been built different ways.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

If you're running over a LAN, keep the BE on the server, and give each user their own copy of the FE, either on their HDD (what I personally do) or on the server I guess.

Replicas are generally used for when people can't access the data from one source, ie sales reps out on site on a laptop.


1) do not use Replicas.  Replication is only applicable when you have some users who t\otally disconnect from the network (travelling with a laptop for instance).

2) I prefer the Single 'FE" with Links on each user's desktop - makes updating the FE a breeze - and I have never had any problems with that configuration.  Others will argue the other way - a copy of the FE on each Desktop., but to me that makes it a real challenge to make sure that, if and when you change the FE, everyone is now using the newest version.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Typically all users should have their own frontend, and all frontends should connect to the same backend.

You are correct: Replicas should not be used to deploy frontends. Replicas should be data only, and typically you would distribute a replica to a "group" of users (like a remote office, for example). All of those remote users would connect to the replica. Replicas should never deploy objects; doing so almost guarantees corruption of the replicas (and eventually the design master).

As network speed increases, we seem to be seeing an increase in the "link to the frontend on remote server" setup, however the only benefit this provides is easier deployment (at the expense of performance, of course).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

the way i do it is have each user have their own front end on their local hardrive.  keep the main one on the server.  then when u update the one on the server, when someone goes into their local ones on the hard drive, a seperate program deletes the local one and updates it.  this makes it very easy,.
A little late, but I'm going to echo what everyone else here has said.

I've developed a few database apps in my day and I've found that the best way to go is BE on the network and FE on each users machine.  

Typically what I do with my apps to make new FE deployment easier is write a VB EXE that I stick on the network and tell everyone to run.  That EXE then copies the new FE off the network down to their local hard drive and also adds their name to the "update log" so that i can track users that have updated.  

Anyways, that's what has worked best for me in the past.

One other point to make note of is that some companies are going to "locked down" PCs where each users PC is "locked" and they can't write anything to the hard drive.  I know this sounds silly, but in this day in age of spyware, adware, viruses, etc. some companies are going toward this locked down approach and all of your data storage is on the network.  All software, patches, hot fixes, etc. are installed remotely by Administrators.  Anyways, just throwing that out there to point out that the FE on the users hard drive is not always possible.

Hope this helps.

Along with the above votes for local FE for each user I like to put static tables, personal tables (user settings) and temp
tables for those impossible reports into the FE. I find this makes enough things easier so it outweighs any issues I have with distribution.
machine_runAuthor Commented:
Thanks to all.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.