I am using access 2002
I thought I new security very well until this happened.
I used the Access wizard to do all the right things such
as removing all the permissions from the default Admin
User and using groups, changing owner etc. A new
AdminsMember is created who belongs to the Admins group.

I have created 3 new users
user1, user2, user3;
Admin user is already there; All 4 Users belong to the
Users groups.

None of the above Users have any passwords for simplicity.

Here is the problem
Nobody except the AdminsMember can log into the database?
I can log in as the AdminsMember and have all the Admins
group permissins I want, this is fine and dandy.

But when I try to log-in as user1 or user2 or user3 or
Admin with no password they are all locked out!!!
Why is this?

I am using the same secured.mdw file and everybody is in
the same workgroup.

Thanks for any help
ravi

I think I found the answer myself.
I had run the security wizard a second time and took the
defaults of no permissions on the database for the "users"
group, this locked out all my Users (user1, admin, etc);

I reran the security wizard and after I gave permissions
to the Users to open and run the database then all the
Users were able to open the database again.

So I guess I do know a little bit of Security, after all.
Thanks

>-----Original Message-----
>I am using access 2002
>I thought I new security very well until this happened.
>I used the Access wizard to do all the right things such
>as removing all the permissions from the default Admin
>User and using groups, changing owner etc. A new
>AdminsMember is created who belongs to the Admins group.
>
>I have created 3 new users
>user1, user2, user3;
>Admin user is already there; All 4 Users belong to the
>Users groups.
>
>None of the above Users have any passwords for simplicity.
>
>Here is the problem
>Nobody except the AdminsMember can log into the database?
>I can log in as the AdminsMember and have all the Admins
>group permissins I want, this is fine and dandy.
>
>But when I try to log-in as user1 or user2 or user3 or
>Admin with no password they are all locked out!!!
>Why is this?
>
>I am using the same secured.mdw file and everybody is in
>the same workgroup.
>
>Thanks for any help
>ravi
>
>
>
>.
>

Hi

By allowing permissions for the Users group, you have also
allowed permission for the anonymous Admin user. Therefore
everyone can still open your database. If that was your
intention then that is good. Why not use one of the other
groups that comes with the wizard and then use the
shortcut file that the wizard prepares for you to open the
database.

I have a book detailing how to setup Access security
properly in two months time.

Garry Robinson
Editor of www.vb123.com

>-----Original Message-----
>I think I found the answer myself.
>I had run the security wizard a second time and took the
>defaults of no permissions on the database for
the "users"
>group, this locked out all my Users (user1, admin, etc);
>
>I reran the security wizard and after I gave permissions
>to the Users to open and run the database then all the
>Users were able to open the database again.
>
>So I guess I do know a little bit of Security, after all.
>Thanks
>
>>-----Original Message-----
>>I am using access 2002
>>I thought I new security very well until this happened.
>>I used the Access wizard to do all the right things such
>>as removing all the permissions from the default Admin
>>User and using groups, changing owner etc. A new
>>AdminsMember is created who belongs to the Admins group.
>>
>>I have created 3 new users
>>user1, user2, user3;
>>Admin user is already there; All 4 Users belong to the
>>Users groups.
>>
>>None of the above Users have any passwords for
simplicity.
>>
>>Here is the problem
>>Nobody except the AdminsMember can log into the database?
>>I can log in as the AdminsMember and have all the Admins
>>group permissins I want, this is fine and dandy.
>>
>>But when I try to log-in as user1 or user2 or user3 or
>>Admin with no password they are all locked out!!!
>>Why is this?
>>
>>I am using the same secured.mdw file and everybody is in
>>the same workgroup.
>>
>>Thanks for any help
>>ravi
>>
>>
>>
>>.
>>
>.
>