Access Database in Multi-User enviroment

What steps should I take to ensure optimal functionality of an Access Database in a multi-user (2 - 10 users) environment?  By the way, there are several sub-forms, which seems to complicate the issue.
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Assuming you have already split the database into a FE/BE scenario, here is a recent EE thread with a load of good information and things to consider.  This is not a black and white subject.  Let me know if you have any further questions :-)

Also ...even though a bit lengthly ... and yet unresolved ... this gives you an idea how what can 'come up' ... so to speak, but not meant to scare you:

Split the database between a frontend (programs) and backend (data) and give each user a local copy of the frontend, linked to the back end on a network share
cquinn is right. here is a linkt o additional info on splitting:
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

All previous posts are correct - Split. Before splitting, make sure to make a back up copy of the Db in case something funky happens.

Also, if each user has separate needs I would restrain from creating a different Front End for each user. Instead, have one FE Db and create permissions for certain portion of the FE DB.
saleve does need to have a front end for each user. not because they have "special needs" but because he is going to split the database.
as cquinn stated, all users should have a local "copy" of the front end on their machine to prevent locking. this is a standard setup for a split database.

SaleveAuthor Commented:
Thanks to everyone who answered.  I had actually already split the database. Since reading the links provided by MX, I realize that I should have asked more specific questions.  I will do this separately.
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.

All Courses

From novice to tech pro — start learning today.