Matt said:
Within my database i have set up user groups with passwords and then
have related user permissions.
Perhaps you meant this, but thought I'd clear it up: Groups don't have
passwords; also you should just assign permissions to groups and not users,
and just make the users a member of the appropriate group. It is easier to
manage security that way.
When a user tries to access something they aren't allowed to the error
message comes up as "There was an error executing the command".
Is there any chance of changing this text?
How about doing away with the opportunity for the message to come up at all?
If you have used the switchboard manager to create a main menu, consider
creating your own. You just need an unbound form with all the command
buttons you like on it. It's easy to program the command buttons to open
various forms/reports.
Also this gives you the flexibility of hiding buttons that the current user
shouldn't see. If they don't see them, they can't click them and get the
message.
There is code in the security FAQ you can use to determine if a user is a
member of a group. You can check this in the Open event for your main form,
and then set the visibility of various buttons based on group membership.
FAQ
http://support.microsoft.com/?id=207793