Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Stripping Security from a DB

Discussion in 'Information Technology' started by Grumpy Aero Guy, Jul 28, 2006.

  1. Grumpy Aero Guy

    Grumpy Aero Guy
    Expand Collapse
    Guest

    What is the procedure for removing all security from a database assuming I
    am the admin and have those privilages.

    I have become the Access "go-to" person at work, and, believe it or not,
    someone approached me with an Access 95!!!!!! database that they finally
    decided to upgrade to 2000 (geeez)

    I am seeing an issue that I believe would go away if I could strip all of
    the security out of the 95 DB.

    Any ideas?

    --
    Grumpy Aero Guy
     
  2. Loading...


  3. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    Login as a member of the Admins Group, or the owner of the mdb.

    Grant full permissions to every object (don't forget the database object) to
    the Users Group. Close Access.

    Use the workgroup administrator to make sure you are joined to the standard
    system.mdw that ships with Access.

    Open Access and create a new mdb (you should get no login prompt).

    Import everything from your mdb. This new mdb will be unsecured.



    --
    Joan Wild
    Microsoft Access MVP

    Grumpy Aero Guy wrote:
    > What is the procedure for removing all security from a database
    > assuming I am the admin and have those privilages.
    >
    > I have become the Access "go-to" person at work, and, believe it or
    > not, someone approached me with an Access 95!!!!!! database that they
    > finally decided to upgrade to 2000 (geeez)
    >
    > I am seeing an issue that I believe would go away if I could strip
    > all of the security out of the 95 DB.
    >
    > Any ideas?
    >
    > --
    > Grumpy Aero Guy
     
  4. Grumpy Aero Guy

    Grumpy Aero Guy
    Expand Collapse
    Guest

    Thank you, I'll give it a shot

    --
    Grumpy Aero Guy



    "Grumpy Aero Guy" <fb@beerme.org> wrote in message
    news:yn9sg.20860$u11.9482@tornado.ohiordc.rr.com...
    > What is the procedure for removing all security from a database assuming I
    > am the admin and have those privilages.
    >
    > I have become the Access "go-to" person at work, and, believe it or not,
    > someone approached me with an Access 95!!!!!! database that they finally
    > decided to upgrade to 2000 (geeez)
    >
    > I am seeing an issue that I believe would go away if I could strip all of
    > the security out of the 95 DB.
    >
    > Any ideas?
    >
    > --
    > Grumpy Aero Guy
    >
    >
    >
    >
     

Share This Page