Results 1 to 8 of 8
  1. #1
    laqa is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Rio de Janeiro
    Posts
    15

    Protecting a field with password


    Hello, is there a way to protect one field only in a database? Thanks, Luis.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    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

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    laqa is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Rio de Janeiro
    Posts
    15

    Sorry, from non authorized people to change it.

    Quote Originally Posted by Gicu View Post
    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
    Sorry, from non authorized people to change it.

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    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

  6. #6
    laqa is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Rio de Janeiro
    Posts
    15
    In a form would be fine. Thanks, Vlad.

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    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
    Attached Files Attached Files

  8. #8
    laqa is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Rio de Janeiro
    Posts
    15
    Solved, thanks a lot, Vlad.

    Quote Originally Posted by Gicu View Post
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Password Protecting PDF documrnts from MS Access
    By Ziyaadkhan9@gmail.com in forum Programming
    Replies: 1
    Last Post: 07-22-2014, 06:03 AM
  2. Password Protecting the backend database
    By data808 in forum Security
    Replies: 7
    Last Post: 02-24-2014, 10:45 AM
  3. Password protecting a table?
    By Celx in forum Security
    Replies: 2
    Last Post: 12-17-2011, 02:09 AM
  4. Replies: 7
    Last Post: 09-13-2011, 01:38 PM
  5. Password protecting db
    By lmp101010 in forum Access
    Replies: 1
    Last Post: 12-20-2009, 03:25 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums