Login to different forms based on user

[reynastus]

Hi All

Just wondering if anyone knows a way in which I can have the 2 different user groups log into different forms in access

The aim is not to have a massively secure database more just to have some options available to some users and not to most users. My usergroups would be

Admin - able to access more of the database
Users - able to access most of the db but some not easily accessed.

Firstly I have to stress the point that this does not have to be an extensively secured DB. Most of the people using this DB have very little experience with access in general (as they find excel daunting and prefer to do everything in word) so disabling all the toolbars and maximising the form on startup is more than necessary for protecting the contents of the DB. The DB does not contain vital information either ... just information that people would find useful.

Things I dont need/really want - User logging (time date etc.), extra privs / limited privs etc.

so 2 users in total.

the "Admin" user would log into the "Menu" form and the "user" user would log into the "frm_NA_Menu" form

See attached DB for example

Cheers for any assistance

Rey

[alansidman]

Look at this thread.

http://www.mrexcel.com/forum/showthread.php?t=248191

I use this concept of menus to restrict access and all access to different forms for different users based upon their designated roles. It is a very slick and effective method.

Alan