Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Resetting Security Permissions (97)

    The scenario: someone created a database and set permissions on a table so that certain people could not insert any new records, only view the existing ones. That person has since left the company, and now the people that could only view records need to be able to insert them. Is there a way to reset those security permissions?

    -Kelley

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resetting Security Permissions (97)

    It will depend on how the data has been secured.

    Has the database been secured using the security set up so that you have to log on as a user and do you have the names and password for it?

    Have you tried getting at the data from the tables directly? it could be the form design that is locking you out.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resetting Security Permissions (97)

    I will have to ask them if they are logging on to the database. If that's the case, they have no idea what the administrator database password would be, that person has left the company.

    Also, they are in fact trying to insert records directly into a table, they are not using a form to try to insert the data.

    -Kelley

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Resetting Security Permissions (97)

    If they are trying to enter records directly into the table, you're well rid of the former "programmer". Anyone who allows users direct access to the tables should be shot at dawn ... with no blindfold! That is absolutely the surest way to mess up your database in a hurry. Users can't resist trying things out, with predictable results. However, if they can't enter data into the tables but they can *see* the tables and view their records, then the database is either secured or hopelessly corrupted.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resetting Security Permissions (97)

    Try creating a new, empty database and importing everything from the old database into it.

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resetting Security Permissions (97)

    Charlotte - the database appears to have been secured at some point, and the person that secured it is no longer with the company. We are about to try exporting into a new database, but I just wanted to confirm - is there a way to get around the secure settings and reset them?

    -Kelley

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Resetting Security Permissions (97)

    If the database was properly secured using the 97 security wizard, then it's very difficult (maybe impossible depending on how much you want to spend), to crack the security being used. On the other hand if they simply gave a password to the admin account, and created other userid logins, it isn't that difficult. The import into a new database usually works in that situation. Another strategy is to copy the data records and paste them into Excel, or into an empty table in a new database. That only requires that you have the ability to read the data in the tables.
    Wendell

Posting Permissions

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