Re: Securing a database -- Please refresh my memory

On Fri, 06 Feb 2009 02:15:52 -0800, Bill E. wrote:

Thanks Rick. What do you suggest I do to secure it properly, using my
current workgroup file?

Bill

Check the most common mistake first. That is leaving 'Admin' as the
owner of the database. Owners of objects have "rights" even if they have
zero "permissions".

If that is not it I suggest getting one of the very explicit step by step
guides people have made available on the web and starting over. Keith
Wilby provided a link to his site that has one in his response to your
post.



--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.

Relevant Pages

  • Re: unknown database owner
    ... cleared for the 'Admin' user. ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • RE: Access 97 Security issue Cant make a MDE
    ... "If the database is secured using user-level security, ... logged in as the owner of the database, or at least a member of the Admins ... > the dayabase as a user AND can sign in simply as admin, ... > that the user account has Modify Design or Administer permissions for the ...
    (microsoft.public.access.security)
  • Re: silly question
    ... >have read about problems of the owner of the object, ... >referring that a person who has Admin rights on the Windows operating system ... I have a paper that may help with your understanding how security work ... >If my understanding is correct, I created a database on our server, I'm not ...
    (microsoft.public.access.security)
  • Re: User Level Security Malfunction
    ... The person who logged on to Access when the database was created is the owner. ... If you are listed as the owner, you created the database while logged on as yourself, not as Admin. ... Are you opening the database by way of a shortcut that includes the path to the Security.mdw file, or have you changed the default mdw file on your installation of Access? ...
    (microsoft.public.access.security)
  • Re: Access 97 Security issue Cant make a MDE
    ... I am not able to CHANGE these rights. ... Normally I work as both the Owner of the database (and all objects ... we don't reset this table permission after making the mde. ... we give database admin permission to our user group. ...
    (microsoft.public.access.security)