Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    97 (User Permissions)

    Hi,

    I am working on a database that was built by someone else who is nowhere to be found. He set Admin and user permissions. I would like to remove them for two reasons = mainly so I can work on the database at home and second so I can have the 7 different people using it run the database from their C drive. Presently they all run it from the server and its painfully slow. The tables are split and have permissions on them. I followed the directions in access for removing permissions but had no luck. I know it must be able to be done. The only groups are Admion and User.

    What am I missing?
    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 97 (User Permissions)

    From the Access Security FAQ:
    <hr>How can I "de-secure" a database?

    You need to have Administer permissions and/or be a member of the Admins group. Grant full permissions to the Users group and the Admin user account. Put the Admin user back in the Admins group and remove the password from the Admin user. You will not be prompted for a logon ID and password once the password is removed from the Admin user. Optionally, you can also run the Security Wizard again to transfer ownership of all objects back to the Admin user, but the wizard will also remove permissions from the Users group, which you may not want.<hr>
    HTH

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 97 (User Permissions)

    Thanks! I'll give it a shot!

    Alicia

Posting Permissions

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