Hello, is there a way to protect one field only in a database? Thanks, Luis.
Hello, is there a way to protect one field only in a database? Thanks, Luis.
Hi Luis,
Protect it from what? Viewing (in what - table, query, form), editing, etc. While there is no built in way to do it I was able to achieve that in several ways in forms. So remember, don't give users access to the table (or editable query) containing the field and you should be able to do it in a form.
Cheers,
Vlad
For example a password?
Suggest you encrypt the data.
When you need to read it, it will of course need to be decrypted but both parts can be done by code.
Sorry, from non authorized people to change it.Hi Luis,
Protect it from what? Viewing (in what - table, query, form), editing, etc. While there is no built in way to do it I was able to achieve that in several ways in forms. So remember, don't give users access to the table (or editable query) containing the field and you should be able to do it in a form.
Cheers,
Vlad
As I said, if in a form it is a very easy task = many ways to do it, in a table or query not so much. Would you please explain your requirement in few more words?
Cheers,
Vlad
In a form would be fine. Thanks, Vlad.
Here is the easiest way, using a simple inputbox in the before update event of the control on the form (the password is Luis). There many other ways to do it depending on what you need (i.e, if you have a login form for your db you can automatically grant access to the field to certain users).
Cheers,
Vlad
Solved, thanks a lot, Vlad.
Here is the easiest way, using a simple inputbox in the before update event of the control on the form (the password is Luis). There many other ways to do it depending on what you need (i.e, if you have a login form for your db you can automatically grant access to the field to certain users).
Cheers,
Vlad