Error handling for unauthorized form access

[Creosote65]

Hi all,

I have just implemented security on a database to restrict access to certain parts. This database is completey menu driven, so I restricted the access to a number of forms that guide the user to the various user forms and reports.

My problem is that I get a vba runtime error 2603 ("You don't have permission...") when the user clicks on the command button used to open an unauthorized form.

I already have error handling in some of the forms. Do I have to set error handling for this type of error on every form in the database, or can I somehow set a general error trapping in the general vba module that I have already created?

Thanks,
Creo!

 

[PHV]

You may also consider disabling the unauthorized buttons.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Creosote65]

How do I disable a command button based on a workgroup?