J
james.eacret
Good day all.
I am currently working on an Access (2003) db with a windows
environment. I have been asked to add a login form. This seems very
standard, and mostly it works fine. The catch is that there has to be
permissions assigned when logged in.
Basic Idea:
Three Users in the db
Admin -- Full Access (passwd protected)
Operator -- Read & Write in the forms and generate reports (passwd
protected)
Readonly -- Only be able to view Forms and reports
There are quite a few forms in the db, I would rather not go into each
one and add the code where if user = Readonly, foobar.form = Read Only.
Or something to that extent.
I created the Operator and Readonly account using the security user and
group settings in Access. Then made Access prompt for a user name and
password. However the db owner wants a drop down menu to list the
three types of users and then have a password for the Operator and
Admin user.
Is there a way to have a form pass along the user to the db in order to
use the set permissions?
Thanks for the help!
I am currently working on an Access (2003) db with a windows
environment. I have been asked to add a login form. This seems very
standard, and mostly it works fine. The catch is that there has to be
permissions assigned when logged in.
Basic Idea:
Three Users in the db
Admin -- Full Access (passwd protected)
Operator -- Read & Write in the forms and generate reports (passwd
protected)
Readonly -- Only be able to view Forms and reports
There are quite a few forms in the db, I would rather not go into each
one and add the code where if user = Readonly, foobar.form = Read Only.
Or something to that extent.
I created the Operator and Readonly account using the security user and
group settings in Access. Then made Access prompt for a user name and
password. However the db owner wants a drop down menu to list the
three types of users and then have a password for the Operator and
Admin user.
Is there a way to have a form pass along the user to the db in order to
use the set permissions?
Thanks for the help!