Trap security error

[JEM]

Hello. I have an Access 2003 - SQL Server 2000 database. I have set
up windows authentication security, defined roles, their permissions
and assigned users to those roles. I would like to able to change the
error message that the user receives when they try to update data in a
form that they are not allowed to. For now, they get the standard
"UPDATE permissions denied on object...." and then it brings them back
to the form. I have been trying to trap this message in order to give
them a more user friendly message but haven't figured out on what
event to do this. Any help would be much appreciated!

Jenn

 

[Tom van Stiphout]

On Thu, 27 Mar 2008 13:27:36 -0700 (PDT), JEM <[email protected]>
wrote:

Check out the Form_Error event.
-Tom.

 

[JEM]

Check out the Form_Error event.
-Tom.





- Show quoted text -

I tried that, but i cannot find the error number so was unable to trap
it.

 

[Tom van Stiphout]

Set a breakpoint there, make the error happen, and the DataErr value
will be the error number.
You can even temporarily put in a messagebox:
Msgbox "Tell Jenn that the error is " & DataErr

-Tom.

 

[JEM]

Set a breakpoint there, make the error happen, and the DataErr value
will be the error number.
You can even temporarily put in a messagebox:
Msgbox "Tell Jenn that the error is " & DataErr

-Tom.





- Show quoted text -

Got it. Thanks!