Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have set up a condition as follows:-
subfield (OSUser(),'\',2) = 'hh57906'
or subfield (OSUser(),'\',2) = 'hb53567'
or subfield (OSUser(),'\',2) = 'ss56686'
Initial only user hh57906 and hb53567 had access and ss56686 was excluded. This worked as it should
I then added ss56686 but the user still can not access this file
Does anyone know why this might happen?
Thanks for any help on this.
Edit
I tried saving this file under another name That is I saved the file under a different name and gave this user right to access this file
This worked
So it seems as if something has been saved on the users computer that has set the old preferences
Message was edited by: Robert Hutchings
Message was edited by: Robert Hutchings
Thanks for your suggestions
I will try the above
I have also deleted the user and added back but it still made no difference
edit This solved the problem. I just had to wait for the quarantine period to expire and remove the user completely. And then log them back on
It seems for some reason that the user settings are locked
I have not had this problem before. That is I have changed other users settings
I would maybe take a look and make sure that other user doesn't have different case letters, upper() the whole statement and give that a try
Edit: Could also change the statement to a match instead
Match(Upper(subfield(osuser(),'\',2)),'HH57906','HB53567','SS56686')
hope that helps
Joe
Thanks
But it is lower case
I will try match and see if this amkes a difference
But it also includes for another sheet
subfield (OSUser(),'\',2) <> 'hb53567'
and subfield (OSUser(),'\',2) <> 'bb53571'
//and
//subfield (OSUser(),'\',2) <> 'ss56686'
He was excluded from this sheet but changed as follows. But he is still excluded
It seems like the initial setting can not be changed
Does Joe's MATCH statement work for you?
Maybe try to 'trim()' it?
trim(OSUser())
If this doesn't work, try to add a text object to your application with the text =
subfield(osuser(),'\',2)
Maybe something about that user is different then others, maybe it has a different domain group or something strange
I was thinking that too Josh, the subfield is removing the domain out though, which is why I thought about maybe case, does seem like something different on that user though
Thanks for your suggestions
I will try the above
I have also deleted the user and added back but it still made no difference
edit This solved the problem. I just had to wait for the quarantine period to expire and remove the user completely. And then log them back on
It seems for some reason that the user settings are locked
I have not had this problem before. That is I have changed other users settings