J
jleal
Good day:
I have a database, in which I have an administrator account - Administrador
- and a user account - User1. The Administrator and User1 have different
passwords.
What I want is in the form1 (that have several fields) to attribute rights
only to Administrator the update the value list "Comboboxtabel1", and to fill
out the fields automatically "Created by" and "Last modification accomplished
by". The field "Created by" it should be filled out with the name of the user
that created the record (Administrator or User1) and the field "Last
modification accomplished by" it should be filled out with the name of the
user that to modify the record.
Through the configuration of safety of the access, I think that I can’t
specify that the user - User1 - cannot change the value of the value list
"Comboboxtabel1". Or do I can? Which is the variable that stores the name of
the user to fill out the fields "Created by" and "Last modification
accomplished by."
I’m thinking to create a users table and a groups table, to do an entrance
form, where is introduced the user name and the password, later I store the
user in a global variable and the group in another global variable. I can by
this way to fill out the fields that I want and make code that restrict the
action for each group or user. The problem is if there are several users
using the database simultaneously. How is it that I solve this?
I thank your cooperation at once.
With the best regards,
José Leal
I have a database, in which I have an administrator account - Administrador
- and a user account - User1. The Administrator and User1 have different
passwords.
What I want is in the form1 (that have several fields) to attribute rights
only to Administrator the update the value list "Comboboxtabel1", and to fill
out the fields automatically "Created by" and "Last modification accomplished
by". The field "Created by" it should be filled out with the name of the user
that created the record (Administrator or User1) and the field "Last
modification accomplished by" it should be filled out with the name of the
user that to modify the record.
Through the configuration of safety of the access, I think that I can’t
specify that the user - User1 - cannot change the value of the value list
"Comboboxtabel1". Or do I can? Which is the variable that stores the name of
the user to fill out the fields "Created by" and "Last modification
accomplished by."
I’m thinking to create a users table and a groups table, to do an entrance
form, where is introduced the user name and the password, later I store the
user in a global variable and the group in another global variable. I can by
this way to fill out the fields that I want and make code that restrict the
action for each group or user. The problem is if there are several users
using the database simultaneously. How is it that I solve this?
I thank your cooperation at once.
With the best regards,
José Leal