Thanks Mike and Joan for clarifying the User group rights for me. I did some
checking yesterday and found that for some reason the User Group in the
Drawings database has restricted rights (read only) to the table that
contains the data the "Add" form should display. I think what is happening
is that when Joe uses my secure database, he is logged on as a member of the
"Engineers" group. When he switches to the Drawings database, he becomes a
member of that database's Users group (and has a problem with the Add form).
However, when he closes Access and reopens the Drawings database (joined to
the default System.mdw), he doesn't have a problem--because that database
has not been secured and he is logging on as "Admin" with full rights. I
plan to fix the User rights in the Drawing database and see if that solves
the problem.
Vivian
Mike Binger said:
----- Vivian Carroll wrote: -----
In Access 2000, I created a database and because different groups within the
dept needed different access rights, I created "dept.mdw" to define the
groups and users and then in the database I gave appropriate rights to the
users. When the users "join" dept.mdw, they get the proper access to the
database.
However, then they don't get proper access to the existing databases that
the dept has been using. For example, a member of the "engineers" group can
no longer create records in the drawings database because that database only
has "Admins" and "Users" groups. If an engineer has joined dept.mdw and
opens the drawings database, he can no longer edit records and only sees the
header and footer of the "add records" form because he is no longer logged
on as "Admin" so he no longer has add/edit rights. I assume this is normal.
But what is the normal work around? Do I have to teach the engineers the
clumsy process of switching back and forth from being joined to their
C:\...System.mdw and my dept.mdw? Or, do I have to go into every database
anyone who joins my dept.mdw group will ever use and define the same groups
in those databases and assign rights there too?
TIA,
Vivian Carroll
If you go to Tools - Security - User and Group Permissions for any of
those other databases, I think you will find that the Users group has full
permissions for any object. Any member of the 'engineers' group is also
automatically a member of Users (that's a given). So any user will be O.K.