Good morning !
To bcooney: Funny, I thought it was your signature but I just wanted to explain it is not the cause for this problem/bug.
To Mr. Blackwell: I don't want to insist, but I tried using the exact() function as you proposed and it didn't fix the problem. Now, you know how much I love the security module who was introduced in FM version 7. I think it is thousands of time better than the primitive password-based 'security' for FM 6 and previous. I want this module to be as best as possible ! But I think the problem I describes is very important because some FileMaker solutions are now unsecured.
I make a new version to show the problem I'm talking about. It is available here as ...version2. To fully understand the issue, you have to make the same operations with FileMaker version 9 (or previous), then close the file, then open FileMaker 10 and try the same operations.
In FM10, FileMaker won't display the "no access" message (resulting of the view limited calculation) AND it won't disallow read/write permissions (resulting of the edit limited calculation) for users who belongs to the restricted Privileges.
I think I'm gonna report the bug to FMI as suggested by Comment ! Hopefully, they will listen even if I never wanted to be a FSA/FBA member. :)