I've run into a situation where I have set access restrictions for a low end user level to only a particular part of the solution. The solution is set up so these low end users can normally only see there own records.

However, it is possible for the user to enter find mode and perform a query in a field that I have to give them access to. (I can't cover it up with an invisable box as they are required to enter data in it.) They are then able to see other users records.

Am I missing something in FM's security setup that would prevent the Find Mode from being available? Is a plug-in my only option? re: FMSecure or other?

You might use a script to check the current mode.

If(Status(CurrentMode) = 1,"DON'T ALLOW ACCESS","Do whatever")

This topic is being moved to Security Issues.

Just an aside about protecting fields with an invisible box. You can assign a button to the invisible box that only performs a "GoTo Field" if they are in Find mode. -bd

Under the user's password, set the Available Commands to either "Editing Only" or "None".

The "Editing Only" will only allow the users to edit text within the fields they have access to. Everything else you will have to set up for them via buttons/scripts.

They will only be able to do what you provide them with buttons.

Did you know that by changing "Available Commands" in the password screen, that you can limit access to the menu items?

All great suggestions, thanks.

In this particular case the solution in question was inherited and lacks a good button interface. So using the regular FM menu access re: Editing Only or None removes some of the required functionality. I guess I was looking for a quick fix and removing JUST the find functionality would have done that. Oh well, ho ho ho, it's off to work I go.