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
"GD" <(E-Mail Removed)> wrote in message
news:1B7822DE-A04A-44BC-8F30-(E-Mail Removed)...
> 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!
> --
> GD
Similar Threads
