Re: Locked Out of DB object

From: Nelson Ferry (anonymous_at_discussions.microsoft.com)
Date: 06/03/04

  • Next message: Rick B: "Re: Access 2002 vs 2003"
    Date: Thu, 3 Jun 2004 09:19:03 -0700
    
    

    Thanks for the information.

    I have not been able to locate the MDW file for this DB.
    Also the individual that created the DB was the only
    person that had Admin privledges. Is there any way to
    reset the security level so that I can access this
    information?

    Thanks Again

    >-----Original Message-----
    >You inherited a mdb, but did you also get the mdw with
    it? Try searching
    >for all mdw files. The system.mdw path you provided may
    be the standard
    >workgroup that ships with Access, rather than the one
    used to secure the mdb
    >with.
    >
    >You need to find the right workgroup file, and also need
    the
    >username/password of a user that's a member of the Admins
    group in that
    >workgroup.
    >
    >--
    >Joan Wild
    >Microsoft Access MVP
    >
    >"Nelson Ferry" <nelson_ferry@sra.com> wrote in message
    >news:17aaf01c44980$46c4ca40$a301280a@phx.gbl...
    >> Hello,
    >> I inherited an Access 2002 DB with security applied. My
    >> workgroup information is below:
    >>
    >> C:\PROGRA~1\COMMON~1\System\SYSTEM.MDW
    >>
    >> Every time I try to open the objects in the DB I get the
    >> following error:
    >>
    >> You don't have permissions to run 'Form Name'(or any
    other
    >> item whether it be a table, report, macro, etc.)
    >> To run this object, you must have Open/Run permissions
    for
    >> it. For more information on Permissions and who can set
    >> them, click Help.
    >>
    >> The previous owner left before I got here and I have no
    >> idea what the Admin password was. I can not find a
    >> security file for this DB. I have tried going in and
    >> assigning all permissions to all objects to the users
    >> group, however, I get an error telling me I do not have
    >> permissions to do this. I need to be able to access all
    >> of the items in this DB. I tried taking ownership of
    the
    >> file and then changing the security settings, however,
    >> that did not work either. There is a shortcut to the
    file
    >> in the same folder, however, Ireceive the same erro
    >> message when I try to open the DB using the shortcut as
    >> well. What can I do in order to get access to these DB
    >> objects and then be able to setup my own security policy
    >> on the DB? Thanks for any help in advance.
    >>
    >
    >
    >.
    >


  • Next message: Rick B: "Re: Access 2002 vs 2003"

    Relevant Pages

    • RE: Any way to remove ADMIN$ only?
      ... partition to allow you to set local permissions. ... Network Security Specialist ... Any way to remove ADMIN$ only? ... default security of Windows drives. ...
      (Focus-Microsoft)
    • RE: Any way to remove ADMIN$ only?
      ... The different recommendations or best practices are pretty much just ... the time in the basics of setting up security. ... NTFS permissions are where you do the real work, ... Any way to remove ADMIN$ only? ...
      (Focus-Microsoft)
    • Re: What server hardening are you doing these days?
      ... admin" not doing their job and testing the changes they made. ... >MS-published security guidelines. ... >>an NT box by denying LocalSystem permissions to certain files. ...
      (Focus-Microsoft)
    • Sorting out security
      ... MS Access security. ... created a new workgroup, added a password for the Admin role, added groups, ... user IDs and passwords for users and allocated permissions on the ... remote logins to a secured database. ...
      (microsoft.public.access.security)
    • Re: system.mdw
      ... Id, give admin all the rights, and he would be able to do about anything EVEN ... thanks again....very helpful just to know that the owner was stored ... user, modified the user group permissions, etc. ... open my project, if the default mdw file is the "system.mdw", then ...
      (microsoft.public.access.security)