[AccessD] Limiting User Navigation to Forms

If you want to limit opening forms by department, I would have a backend 
table with userid and department
Then before opening the form I would check the userid in the table 
against something like this code to verify against the machines network 
logon id
If you could obtain the network logon password, you would break network 
security.
Depending on the way your network security is setup you might be able to 
get the network id's group name.
This code is a little longer that most posted on the net to obtain the 
network login id and is more robust.

http://vbnet.mvps.org/index.html?code/network/netusergetinfo.htm
http://vbnet.mvps.org/code/network/lookupaccountname.htm
http://vbnet.mvps.org/index.html?code/network/netwkstagetinfousername.htm

Nicholson, Karen wrote:

>I have about 50 users in 10 different departments.  Based on the user
>network login id, I want to limit the users ability to open up various
>forms - for instance, someone in the QA department would receive a "you
>are not authorized to open this form" message box  when they try to open
>up the AS departments data entry forms.  I don't want to have to code in
>each form that needs limitations an on open event to evaluate the id's
>and let those authorized through.  Has anyone built a table to hold
>network logins with passwords that are evaluated on form openings?  
>
>
>
>Karen Nicholson
>National Laboratory
>Xerox Global Services
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada