first off this was posted on another part of Access Forum to which it was suggested if that answer couldnt help then to come here...
I want that when an employee logs in to their computer and brings up the database that their privilges are already assigned in this DB - by their First Name and Last Name - my question is 2 fold...
1. their log in usually consists of 2 letters and 4 numbers - i believe i will need to add this to their name in the Employee table/query i have ...correct?
2. and in doing so will need to put this somewhere in the DB for when they click it that makes it impossible for them to select another user in the DB to be able to have more control.
i went to http://www.dbforums.com/6332819-post68.html (from the other reply in the other post) and read that but not what i want as i already have the certain privileges set up in this DB - but if i have to change this please let me know and advise on how i could do this..
TIA
Stephanie