Connecting Tech Pros Worldwide Help | Site Map

Security Wizard but Not Secure

  #1  
Old May 16th, 2006, 01:05 PM
drink.the.koolaid@gmail.com
Guest
 
Posts: n/a
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

  #2  
Old May 16th, 2006, 02:05 PM
Keith Wilby
Guest
 
Posts: n/a

re: Security Wizard but Not Secure


<drink.the.koolaid@gmail.com> wrote in message
news:1147781112.258494.175040@i39g2000cwa.googlegr oups.com...[color=blue]
> 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?
>[/color]

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


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
secure replication for remote locations techbuddha answers 1 January 25th, 2008 03:12 PM
Access Security without using the Security Wizard thebarefootnation answers 7 October 27th, 2007 09:25 AM
Microsoft Access User level security wizard sed answers 1 September 9th, 2006 05:48 PM
How to secure an A97 database from being opened w/o the correct system datbase being in place MLH answers 11 November 13th, 2005 12:36 PM