Using logon name and password within a form

31 Dec 2008 1:49 PM

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!

--
GD

28 Jan 2009 11:52 PM

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

Show quoteHide quote

"GD" <g*@discussions.microsoft.com> wrote in message
news:1B7822DE-A04A-44BC-8F30-BF7D4E407ED4@microsoft.com...
> 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