If you have set up your database to have different levels of security I was wondering if there was a way to detect the level of authority in VBA and set up locking accordingly. I know you can use CurrentUser to identify a user but I want to be able to allow or stop a person changing a field depending on whether they have admin permissions.
Scenario:
On current
Check level
if level=Admin
Field.locked = False
Else
field.locked = True
End If
Or do I just really want Oracle..........
Thanks
Scenario:
On current
Check level
if level=Admin
Field.locked = False
Else
field.locked = True
End If
Or do I just really want Oracle..........
Thanks