Most efficient way to run a shared Access Program

Hello All,

I have an Access 2010 database on a server.  Right now the Access database is not split into a FE and BE.  I put a shortcut directly to the database on each user's desktop.  My question is, what would be the most efficient way to have them all use it?

1. Keep it as is
2. Split the database on the server into a FE and BE and connect them to the FE via a shortcut
3. Split the database on the server into a FE and BE and put a local copy of the FE on each of their machines

The forms in this database are loaded with code.  Nothing super advanced but boatloads of code.

I am not sure which way would cause the least delay and bottlenecks.

Thanks
alevin16Asked:
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.

mbizupNerdCommented:
#3 is the best practice.

Each user should have his/her own local copy of the FE, linked to a shared BE on the network.

In terms of managing FE updates for multiple users, there are plenty of 'Front-End Updaters' available online which will automatically detect version changes and copy an updated front end from a shared network location to a user's computer, and the actual code to build your own FE Updater is fairly straight forward.

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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
As has been said, #3 is the best choice.

 By doing that, only data flows over the network and each user has their own copy of the FE, which makes things like working with temp tables easier because they won't conflict with anyone else.

Jim.
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.