Access levels

[kenshinx1]

Iv got a user table with an admin record and head teacher record with the highest access level

I then have 2 teacher records with a lower access level

The admin and headmaster have access to the whole system this includes assigning user name and passwords. However I don't want the head master to be able to change the admins password, so is there a way to lock this record or even hide it from a user form

 

[neileg]

Depends how secure you want it to be. At its simplest, you could base the form on a query that has a criterion to exclude the admin record.

 

[kenshinx1]

what would I need to write in the criteria box, I have never done anything like that before

 

[neileg]

Whatever the record holds that identifies it as the admin record. Presumably the primary key.

How have you got this far without using criteria in queries? Or did you just not understand what I said? If so, I appologise!

 

[kenshinx1]

Iv done queries before but I have never been able to not show a record on the query. in this case a admin record

 

[neileg]

Your criterion would be something like:
Not "Admin"