Trap security error

  • Thread starter Thread starter JEM
  • Start date Start date
J

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
 
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.
 
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 -
Click to expand...

Got it. Thanks!
 
Back
Top