Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44

    Unanswered: In need of a crash course in assigning users and permissions on an Access Database.

    Please, anyone, point me in the direction of a good site or good person that can walk me through setting up users and a prompt that will verify them with a username and password.

    I have tried to teach myself this aspect of Access and I am ready to pull all the rest of my hair out.

    S.O.S!!!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634

  3. #3
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44
    This looks like it would work, BUT... I can't find the first step. There is no file in the SYSTEM folder like it said.

    Could there be a problem because I am on a network?

    Let me know. Thanks,

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Take a backup of your database and then proceed to stage 2.

    Backups are the key!!
    George
    Home | Blog

  5. #5
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    I'm also on a network. I found system.mdw in the following folder:

    C:\Documents and Settings\"your initials"\Application Data\Microsoft\Access

    HTH
    Sam

  6. #6
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44
    I am running Access 2007... None of these options on the website given are located on Access 2007.

    I have a copy of a database open, and use the securty level wizard. Is that right?

  7. #7
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Access 2007 seems to have drastically changed the built in security. I have not used 2007, but a google search for 'Access 2007 security' turned up several hits.

    Your other option would be to create a user table in your db.

  8. #8
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44
    If I made a table in Access that had usernames and passwords, how will that then verify who is logging in and how will it be able to disable tables and such?

    My end result is to have them use a single form and not be able to enter anything else or edit anything (including LINKED tables)

Posting Permissions

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