How to overcome a deadlock in Admin privilege

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Babu1983
    New Member
    • Sep 2010
    • 2

    How to overcome a deadlock in Admin privilege

    I created a MS access database.
    I had then created a Workgroup Information File using Tools->Security->Workgroup Administrator.
    I created a password for my used id('kanagab' which is same as my windows logon id) and was using the db.

    The user id 'kanagab' was a member of 'Admins' Group and 'Users' group
    There was another user called 'admin' which was ONLY a member of 'Users' group (This is what has mislead me .. ie., I had thought 'admin'user is a member of 'Admin' group too)

    Later I wanted to remove the password for my user id 'kanagab'
    But I had accidentally deleted the user 'kanagab'. Tools->Security->User Groups and Accounts->selected the usaer name 'kanagab'->Clicked 'Delete' button

    So, now whenever I am opening my db, I am logged on as the user as 'admin' only and I do not have any run permissions.
    I am not able to change the ownership of the db back to 'kanagab' because my current id ('admin') does not have administrator previlege.

    I would really appreciate if someone help me on how to log on to my db with Admin previlege?

    (More details in the document attached)

    Thanks
    Babu
    Attached Files
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Contrary to popular opinion, the Admin User can, and should be, removed from the Admins Group as the first step in the process to 'Secure' a Database. I hate to be negative, but from what you are telling me, you are basically stuck.

    Comment

    • Oralloy
      Recognized Expert Contributor
      • Jun 2010
      • 988

      #3
      Well, log-on as admin and try to export everything.

      Then, create a new database, with the appropriate users.

      Finally, import everything and restore any damaged relations between tables.

      Comment

      • Oralloy
        Recognized Expert Contributor
        • Jun 2010
        • 988

        #4
        I just did an experiment with Access2007.

        I created a blank database.

        Then I went to "External Data", and imported from an existing database.

        Perhaps this will help. I don't know if you can do so on your system without Admin priv., or not.

        Comment

        • ADezii
          Recognized Expert Expert
          • Apr 2006
          • 8834

          #5
          You can 'Unsecure' a 'Secured'Databa se, but only if you are a Member of the Admins Group.

          Comment

          Working...