security on replicas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with user level security set up. I have created replicas
and I can't even open them because of the security. When I click the
shortcut so I can put in my username/password it always takes me to the
design master. How can I set it up so that I can open these replicas? When
I tried to create the replicas first and then do the security it told me I
can't do user level security on a replica. The whole reason I need security
is for the replicas. Someone please help me. I am completely stuck. Thanks
in advance.
 
Brent said:
I have a database with user level security set up. I have created
replicas and I can't even open them because of the security. When I
click the shortcut so I can put in my username/password it always
takes me to the design master. How can I set it up so that I can
open these replicas? When I tried to create the replicas first and
then do the security it told me I can't do user level security on a
replica. The whole reason I need security is for the replicas.
Someone please help me. I am completely stuck. Thanks in advance.
Click to expand...

First you should split your database into frontend (all objects except
tables) linked to a backend (just the tables). Only the backend should be
replicated. Do not replicate the frontend. Give each user a copy of the
frontend, which will be linked to their replica of the backend.

You would apply security before you replicate.

The reason your shortcut always opens the design master is because the
target of the shortcut specifies that mdb.
 
So how do I "link" the copies of the front ends with the right replicas? And
how do I set up the shortcuts to open the copies of the front end? This is
becoming very frustrating to me. Thanks so much for the help.
 
Brent said:
So how do I "link" the copies of the front ends with the right
replicas?
Click to expand...

You can use Tools, Database Utilities, Linked Table Manager. Or you could
do it programmically - see
http://www.mvps.org/access/tables/tbl0009.htm for an example.
And how do I set up the shortcuts to open the copies of
the front end? This is becoming very frustrating to me. Thanks so
much for the help.
Click to expand...

Just modify the shortcut to point to the path of the frontend. If the
frontend is installed in the same folder on everyone's computer, you only
need to create one shortcut, and copy it to their desktops. If you are
going to be making design changes to the frontend, you may want to look at a
method of updating users' computers automatically. See
http://www.granite.ab.ca/access/autofe.htm
 
Back
Top