Within my database i have set up user groups with passwords and then have
related user permissions.
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?
Many Thanks,
Matt

Matt Dawson wrote:
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.

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

Security NOT using "mdw" file
Security restrictions and table linking
MDW deployment?
Securing the Back-End
Shorcut with pointing to two ACCESS.EXE
from mdb how to openForm a form in a referenced mde file
Locked Out, what did I do?
Prevent all Access files from connecting to the same Workgroup?
How can I lock based on certain field?
Using Access 2003 security on users with 2002 Access