Thread: Applying rights to access account

Hi,

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

PLEASE HELP ME

Hi,

First of all you will have to create a table for teachers and students say users_tbl.

Then you have to make a column for login id.This login Id performs both the operations like Students, for their ID and Teachers for their username.

You can implement the security code on the form.You can apply permissions on that, like the student will only check their details not modify but the teachers can do everything they want.
Finally you have to check whether the user in a teacher or Student.If the user is student then disable the edit options but if the user is a teacher then allow addition, modification and deletion for that....

Does this work with ACCESS 2007?