help with ULS

[wylie72]

I ran the ULS security wizard, added a bunch of new users / groups,
removed all authorites from the Admin account / User group.

Works just as I expected when I go through the shortcut. If I try to
open it direct it won't open (good). But when someone else on the
network opens the .mdw file it opens no problem with full permissions
under the admin acct. How do I stop this?

 

[Joan Wild]

Why are users opening the mdw file?

You need to test if they can open the mdb file directly in Windows Explorer.
If they can, then you missed a step in securing the database. Depending on
the version, there's more to it than running the wizard.

 

[wylie72]

Sorry, typo (long couple of days). They are able to open the .mdb file
on the network server or by copying to their personal directory.

 

[Joan Wild]

Then you have missed a step in securing it. It's a good test to see if
you've implemented security correctly by trying to open it while joined to
the standard system.mdw workgroup file that ships with Access.

If you've done it right, they won't be able to even open it.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm