User Level Security and Startup

[Ripper]

I used the User level security wizard successfully and now have a question
about the login. I have 5 different groups that will log into the database.
Each one has a different opening form that will take them other places.

Is there a way to have a different startup form for each group that logs in,
or should I make a form where the user selects their type and go from there?

 

[Lynn Trapp]

Check the Security FAQ for code that allows you to detect which group a
user is a member of. Bear in mind that a user can be a member of more than
one group. Then you can use code in an invisible startup form to open the
appropriate form for each person who logs on.

 

[Ripper]

OK I give up. I can't find any FAQ for security in the Help menu or in
Office Online. Where can I find Security FAQ?

Sorry, it is one of those months.

RIP

Check the Security FAQ for code that allows you to detect which group a
user is a member of. Bear in mind that a user can be a member of more than
one group. Then you can use code in an invisible startup form to open the
appropriate form for each person who logs on.

 

[jane]

http://support.microsoft.com/default.aspx?
scid=/support/access/content/secfaq.asp

-----Original Message-----
OK I give up. I can't find any FAQ for security in the Help menu or in
Office Online. Where can I find Security FAQ?

Sorry, it is one of those months.

RIP

 

[Lynn Trapp]

Watch out for word wrap on Jane's link. You need to put all of that in one
line, ripper.