Restricting Edits to records by other users

[basshead22]

Hello I have a timesheet data base and I wanted to find a way to restrict employees from editing other employees timesheets only their own timesheet... .is it possible with access 2010?

 

[CJ_London]

yes - if you want employee A to be able to see employee B's records but not be able to edit them, you can use conditional formating to disable employee B's records.

If Employee A does not need to see employee B's records, use a filter

 

[basshead22]

so I need to create a form to have the user log in first?

 

[CJ_London]

Depends how you want it to work - you can use a form to 'activate' your own login identities - this is what is being described at the moment.

But you can also use the following to get their window login name

Function LoginName() as string
    loginname = CreateObject("wscript.network").UserName
end function

But this will only work if you are sure users aren't using other users logins - i.e. sharing a computer.

In any event, you will also need to add a userloginname field to all the tables where you want to restrict access.

Things get more complicated when you want to have say a manager review their team's entries. In this case you will need to create a table containing a hierarchy to indicate who can see who's entries.