Group:  Microsoft Access ยป microsoft.public.access.security
Thread: Using logon name and password within a form

Using logon name and password within a form
GD 12/31/2008 1:49:00 PM
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

Home | Search | Terms | Imprint
Newsgroups Reader