Please Register to Remove these Ads

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?

Quote:

Originally Posted by CRIMEDOG Does this work with ACCESS 2007?

In access 2007 there is no "Built In" user level security. You have to code you own via vba.

Hope this helps,

Dan

__________________
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!