Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Question account rights

    How to configure accounts for teachers and students, teachers must login with an username and password, students only with studentnumber, teachers cando everything, students only can fill in forms and make printouts( forms and reports).


  2. #2
    islo is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    First you will have to have all the teachers and students in table, say users_tbl. This table, on the least, will have a column for their login id, which will be the student ID for students and a username for teachers.

    Now, the security levels will be enforced on the form level. This means, when a user logs in, and you determine that its a student, you can allow additions, if you want to, but disable editing. This means the students can add new records into the system, but they can edit any existing records.
    If the user is a teacher, you will allow edits and additions, essentially allowing them to enter new records and edit exixting ones.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Admin Rights
    By Keri in forum Security
    Replies: 4
    Last Post: 11-18-2005, 11:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums