Multiuser database in server environment

[Noobe1]

Hi: I need to create a simple database to track trainees and coaches plus all
trainning session. There will be 3 users and we would like to share the
database.

How do I configure Access for multiusers or are there better options.

many thanks

 

[Jeff Boyce]

Bob

Create your application and get it working for you.

"Split" the database into a back-end (holds the data, lives on your network
in a location that all users can 'see'), and a front-end (everything but the
data, linked to the back-end data, one copy per user/PC).

Are your "users" Access-literate? If they aren't, you'll need to design a
graphical user interface so they can focus on their job, not on how Access
does things.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Daniel Pineault]

One extra point about Jeff's explantion regarding Splitting the database.
Once you have split the database (Back-end, front-end). You will place the
back-end in a central location on your server and distribute a copy of the
front-end to each user. they should not be using the same file but rather
each have their own copy of the front-end installed on their local computers.

If you search this very forum, you will find a multitude of exisiting post
on database splitting and multi-user setup.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.