Security Wizard but Not Secure

[drink.the.koolaid]

Hello people.

I have a database that:
* was not secured originally
* I applied the user-level security wizard to
* has the Admin user demoted to the Users group
* had the User's group with no permissions
* the Admin user doesn't own any objects

When I open this with my shortcut and new mdw file everything works as
expected.
When I open this with standard Access security.mdw, my database is
still wide open.

Any ideas what step I missed?

Thanks

[Keith Wilby]

<dr***************@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...

Hello people.

I have a database that:
* was not secured originally
* I applied the user-level security wizard to
* has the Admin user demoted to the Users group
* had the User's group with no permissions
* the Admin user doesn't own any objects

When I open this with my shortcut and new mdw file everything works as
expected.
When I open this with standard Access security.mdw, my database is
still wide open.

Any ideas what step I missed?

Possibly more than one, it's easily done. Have you removed the "Users"
group's permission to the *database* object? The problem with the wizard is
that you don't learn anything about user-level security which is
self-defeating IMO. Have you read the security FAQ (link on my web site)?

Regards,
Keith.
www.keithwilby.com