Using logon name and password within a form

[GD]

Is it possible to:

A) use a logon password to determine a user's level of access or approval
limit within a form? I have a form that allows users to approve paybacks of
deductions, but different users have different levels of approval $ limits.
Can the password they entered upon opening the database disallow them to go
over their appointed limit? I would also like to have a switchboard that
allows certain users to run reports and queries (via command buttons), but
not others, based on their original logon password. Can this be done?

B) auto fill a logon name (entered upon opening the database) with an Iif
expression in a text box of a form:
=IIf([Comments1]<>"",{logon name},"")

I greatly appreciate your time and brain power!

 

[Gina Whipp]

The simple part is yes this can be done. The next set is actually doing it.
However, if your end-users are savvy they will still get past this
'security'.

You can go Joan Wild's website which talks about Access Security
http://www.jmwild.com/Accesssecurity.htm OR you can create some tables and
set-up your own security. Doing your own you will need a Security table and
a table with the users log-on and password. Where are you storing their
log-ons that you want it to automatically fill in or do you want to use
their network log-on?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm