User Level Security and buttons?

[cashe]

Hi All,

A security question has arisen again!!

I have just set up security levels on a distributed Access 2k db. The security stuff is all quite new to me but things are going well so far. However I have a report form where the users can select a variety of reports. The reports open in preview mode from a command button. Some reports should not be opened by certain User Level Groups. For example:

Full Data Users can not open the management reports. If a full Data User trys to open a management report I get the error message "You do not have permission for this report" and then it gives the user the option to "End" or "Debug" which is not very friendly. Therefore the user level permissions are working but how do I make the error message more friendly? what I would like to do is if the management report button is selected by a user group that does not have permission a message appears with "Sorry. You do not have permission to open this report. + vbOKonly" OR hide the management report button to Full Data Users.

How do I do this and what VB is needed?

Thanks

Cashe ;-)

 

[Garridon]

This FAQ should help:

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=1595&CFID=4335264&CFTOKEN=35429210

The above is for trapping forms and reports permissions errors. For queries and tables, use error 3112.

Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[JeremyNYC]

Cashe,

What I would do is put code in the Open event of the form to make invisible any buttons that open reports or forms for which the user does not have permission.

There's code either in the Access Security FAQ or on the MS web site that will show you how to tell if the user is a member of a particular group.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.