Results 1 to 8 of 8

Protecting a field with password

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

    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 Expert
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    861
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,737
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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

    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 Expert
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    861
    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
    13
    In a form would be fine. Thanks, Vlad.

  7. #7
    Gicu's Avatar
    Gicu is offline Expert
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    861
    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
    13
    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
  •  
Tech Forums: Microsoft Office Forums