Security on Tabbed Form?

[Franky G]

Hi,

I have a main form with 5 tabbed pages. These pages relate to various groups within my office. i.e Head of Service, District Manager, Senior Member..etc etc. Each page has command buttons to launch appropriate reports.

Is it possible to restrict each group to their relevant page(s)? I don't want members of staff lower down the tree accessing reports for managers and Director level!

At the moment, it is an unsecured database, using system.mdw. I have used the security wizard previously, is this the best way to achieve what I want? I was thinking of setting up groups, but I'm not sure if Access sees each page as a distict object?

Thanks

Franky

 

[D-Fresh]

You could use a manually created login procedure for this... Have a user log in and have a table set up that has User ID, Password, and access level... if the passwords match, then set the access level to a global variable... and set a public function up to return the access level value... In the click event of the tab, check to see if the access level is high enough. If not, don't allow the page to be viewed, otherwise, let them go. This isn't 100% secure, but it will get the job done and will recognize each page as a different object. Hope this helps.

Doug