I have a test FrontEnd interface in Access Adp format to edit/update data in SQL. I would like Employees to update their own records but how would i go about giving them the frontend interface and only seeing their own records and not everyone else records also. Any ideas/experiences appreciated
Hi Brett, Thanks. As i am in early stages, i could out their employee id in each table no problem. The only thing is, is that each employee does not know that ID So i will have to try and perhaps make some kind if login same where i give them a login name and password and then this login name looks up this Employee ID and returns the records. Would this work do you think?
It would be great if i could get the system to automatically pick up their currently logged in windows username and then reference it against the employee id and return their records
Right. Store the Username of the login that owns the data in a column in the tables. Then create views of the tables that filter to show only those records associated with the current username, and grant access only to those views.
where Username =SUser_Name()
If it's not practically useful, then it's practically useless.