Security Setting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PTS - 17 Jan 2008 21:43 GMT

I am attempting to set security on an Access application. I have read
all documents and have followed the wizards and everything. I have
multiple forms, queries. I have 2 groups and have set the tables and
forms to them along with the users to the appropriate group. It will
not allow me to set the query to the group or user, I get a
Permissions error but I logged on as Admin. The Admins group is
assigned to the Admin user. I cannot open the forms, plus get data
without assigning permissions for the queries to the GROUPS. How do I
do that? I know where to go, but I keep getting the Permissions
error.

Reply to this Message

Olduke - 18 Jan 2008 01:13 GMT

It sounds as though you have made one of the most common errors in the field
of Access security. You have confused the user "ADMIN" with the User Group
"ADMINS" (note the 's' on the end of the group name).
The user ADMIN is the name Microsoft gave to the default user. It was a
stupid selection since by using the name ADMIN the novice will assume that
this user has some administrative capacity.

Please go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald and start again.

> I am attempting to set security on an Access application. I have read
> all documents and have followed the wizards and everything. I have
[quoted text clipped - 6 lines]
> do that? I know where to go, but I keep getting the Permissions
> error.

Reply to this Message

PTS - 18 Jan 2008 16:28 GMT

> It sounds as though you have made one of the most common errors in the field
> of Access security. You have confused the user "ADMIN" with the User Group
[quoted text clipped - 18 lines]
>
> - Show quoted text -

I created separate users. What step am I missing? Am I supposed to
enter the workgroup file before making any security changes?

Reply to this Message

John W. Vinson - 18 Jan 2008 18:03 GMT

>I created separate users. What step am I missing? Am I supposed to
>enter the workgroup file before making any security changes?

Yes.

John W. Vinson [MVP]

Reply to this Message

Olduke - 30 Jan 2008 20:42 GMT

> >I created separate users. What step am I missing? Am I supposed to
> >enter the workgroup file before making any security changes?
>
> Yes.
>
> John W. Vinson [MVP]

Before you even start working in Security:
1. What are your User Groups going to be. This is determined by the
permissions each Group will be given.
2. Assign individual Users to the User Group that has the permissions they
need to do their jobs.
3. You may have dozens of Users in one User Group but only 1 or 2 in
another, based on their requirements.

Admin is nobody. Admin is the default user. Admin has no special
permissions unless you assign them to Admin specifically.

Reply to this Message

Douglas J. Steele - 30 Jan 2008 20:46 GMT

> Admin is nobody. Admin is the default user. Admin has no special
> permissions unless you assign them to Admin specifically.

Not quite. If security is applied properly, Admin is nobody. Unfortunately,
people often forget to remove the Admin user from the Admins group, meaning
that anyone can get into the database simply by using a different MDW file.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message