Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2001
    Thanked 0 Times in 0 Posts

    Removing workgroups (2000)

    I am trying to use an older Access database that was set up using workgroups to give access permissions to the database. We have several users who need to use this database but are not members of the workgroup and do not want to use the workgroup feature. My question is, how can I remove this security from the database? I have one user who is a member of the workgroup and can get into the database this way.


    Donna Poire

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Removing workgroups (2000)

    As long as it isn't completely secure, you can give Users whatever capability they need, and then create a separate system.mdw. However it isn't a very big deal to create additional user accounts (assuming the one person who can get in can do that), and not give them a password. Then they get one dialog box that they simply press ENTER and they are in. If you truly want to remove security completely, and assuming it isn't some sort of commercial product, you should be able to import all of the objects into a new database which will result in the current user being the owner of the database and all of its objects. You may also want to peruse the white paper on security for that version of Access on the MS knowledge base.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts