Need to setup the database for multiusers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary A Perez - 08 Mar 2006 17:50 GMT

This is my first database that I will need to share with multiusers from not
only my department, but from another. The database for all users with the
exception of myself & one or two others from my department will be
"read-only".
At the end of this month, I plan to "go live" & need to as part of that
process to give desktop access to those users to the database.
I need to know what processes I have to do to accomplish this goal.
I also need suggestions on how to make a back-up that I can work on making
updates that I can incoporate at the end of the day after all users are out
of the database.
I hope this makes sense & someone can help me.
Thank you

Reply to this Message

jacksonmacd - 09 Mar 2006 14:02 GMT

Split your database into a frontend component (forms, queries,
reports, etc) and a backend component (tables only). The backend
belongs on a shared folder on your network server, while each
workstation should have its own copy of the frontend.

http://www.granite.ab.ca/access/splitapp/index.htm

Once you have split the database, you will want a method to
automatically distribute any modifications to the various
workstations. Many people use:

http://www.granite.ab.ca/access/autofe.htm

>This is my first database that I will need to share with multiusers from not
>only my department, but from another. The database for all users with the
[quoted text clipped - 8 lines]
>I hope this makes sense & someone can help me.
>Thank you

**********************jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message