Re: Password

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 10:11:10 -0500

The security FAQ has a section on this. Basically you ship a different mdw
than the one you secured it with.

You create the exact same Groups/Users (using the same SIDs), and give the
one person membership in the Admins group. Since the Admins group is
different than the Admins group in your development mdw, they will be able
to manage users, but not change permissions.

More in the security FAQ
 http://support.microsoft.com/?id=207793

Section 33 

-- 
Joan Wild
Microsoft Access MVP
"Ed Crawford" <anonymous@discussions.microsoft.com> wrote in message
news:156f401c41609$30a4a5f0$a401280a@phx.gbl...
> It seems that one either has full access to making
> security changes or no access at all.  I have a situation
> in which I've created a database for someone and I'd like
> to let ONE person at this company have the ability to
> reset passwords but I don't particularly want them to have
> full access to the security system for obvious reasons.
> Any suggestions?

Relevant Pages

  • Re: AllowBypassKey
    ... sequence of the Security FAQ ... So I created a new MDW group, called DISTR, created the SiteAdmin user ... probably drove it home) - that the Admins group is different in each MDW ... > database while logged in as the user you put into the Admins Group. ...
    (microsoft.public.access.security)
  • Re: RWOP queries for back-end secuirty: easy/hard? slow/fast?
    ... of the Security FAQ), while using that secure mdw." ... being created within that database. ... re-opening it with my shared, secure mdw, then importing objects from ...
    (microsoft.public.access.security)
  • Re: Add User To MDW by VBA
    ... >There is sample code in the security FAQ you can use to ... I need to write users in a file .MDW using VBA ... >> user account isn't in .MDW file that I've rapaired and ...
    (microsoft.public.access.security)
  • Re: Password Protect a Control - Access 2007
    ... There is code in the security FAQ you can use to determine if a user is a member of the Admins Group. ... In the open event for the form, you can lock/unlock that control based on group membership. ...
    (microsoft.public.access.security)
  • Re: On open event for form
    ... Use the CurrentUser() function to enter the logged on user into specific ... records and, then, to query those records for the person logged on. ... Security FAQ has code to determine which group a user is in. ... records for a user in the Admins Group. ...
    (microsoft.public.access.formscoding)