Password protected form

A

Adam

Hi All,

I have a database which has two groups of users. The first group
"auditors" I want to give them access to all of the forms, the second
group "team managers", I only want them to have access to 3 forms.

I've looked into user level access and I don't think its appropriate as
I'm on a network and all the computers belong to the same workgroup.

Can I have it so if a form is selected from the switchboard that it
pops up a msgbox and asks for a password?

I've created a table with "Auditors" and "Team Managers" and it has
there passwords in that.

Can anyone help pls?

Adam

Access 97
 
B

Brendan Reynolds

Jet user-and-group level security is probably the best solution - the fact
that you are on a network and that all computers are part of the same
workgroup does not change that at all. Jet user-and-group level security is
completely separate from operating system security.

For an introduction to Jet user-and-group level security, see the following
KB article ...
http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_AcSecurity.asp

Alternatively, for a 'roll-your-own' approach to password protecting a
single form, see the following KB article ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;209871
 
A

Alex White MCDBA MCSE

If you don't want to use user level security, then the following may work
for you.

1 table with username,password, user_level (user,manager)

2 global variables to hold username, and user_level

when you open any of the password protected forms check the global variable
to see if it is <> ""
if it = "" then
you need a dialog form with a username textbox and password textbox
on clicking ok in the form, check the username and password if they match
then load the global variable with the username and load the user_level
global variable with the user_level field from the table.

if they have the correct level of permission then open the form for them

if the global variable <> "" then check user_level to see if the user is
allowed to use the form

I don't normally use global variables but in this case they work very well.
 
Top