How to verify username with Privilege table

[Jon]

Greeting,
I have a form which has a text to get network user name and privilege table
which contains username and privilege fields. Privilege field has 3
recordsâ€Readâ€, “Writeâ€, and “Full Controlâ€. What I want to do is once the
user opens the database, the form addition , deletion….. and other object to
be true if the user privilege is “full controlâ€, addition property is true
if the user privilege is “write†, and all specify properties is false if
user privilege is “Readâ€. How to do that?? Also how to implement with
subforms???

 

[JohnC]

I do this by first using a module that automatically gets the user's LAN
login ID. I do not rely on the user to type this in. The code is run
during a startup form. I also log the opened date, and LAN ID in a table.
If the user is not new, the previous logged record is merely updated. The
same login table contains separate fields for assigned roles with a "Y" if
the user gets that role.

Another module is run on startup to assign values to Boolean variables based
on the assigned roles.

Then each form's open event looks at these variables and determines what
buttons to display, what controls are locked/visible, or other items such as
the ability to add/delete/edit records.

I know this is general but perhaps it might give you some ideas for your
situation. I have used Access User Level Security which is very good but
the maintenance was complicated.

JohnC

I have a table of

 

[Jon]

Hi JohnC,
would you please provide me with these modules and code of the forms please???

"JohnC" كتب: