Results 1 to 7 of 7
  1. #1
    brose is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    4

    Masking Password in table view (not input mask for forms)

    Hello,

    Does anyone know how to mask passwords from being seen in table view? The video tutorial I saw table masking only addressed how to input mask at the form level, but didn't explain how it was hidden in the view shown in the attached print screen. Thanks in advance for any tips you can share.




    Click image for larger version. 

Name:	Capture.JPG 
Views:	24 
Size:	61.5 KB 
ID:	33562

    Thank You,
    Beth

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Table Design View > Input Mask > Password.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  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
    Several things to add to June's reply

    1. You shouldn't allow users direct access to your tables.
    It is easy to add the input mask as June described but equally easy to remove it making all passwords visible.
    2. You shouldn't really be storing passwords in your databases at all for security reasons.
    If you MUST do so, then the passwords should be encrypted before saving so that anyone who sees the data won't be able to use it
    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
    brose is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    4
    Thanks for the reply June7. I had tried that, but it still doesn't mask it in the regular table view. It only masks if I click into the field. Is there another setting I am missing?

    Click image for larger version. 

Name:	Capture1.JPG 
Views:	22 
Size:	99.5 KB 
ID:	33568
    Click image for larger version. 

Name:	Capture2.JPG 
Views:	22 
Size:	26.0 KB 
ID:	33569
    Click image for larger version. 

Name:	Capture3.JPG 
Views:	22 
Size:	24.6 KB 
ID:	33570

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Don't use Format property.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    brose is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    4
    Thanks ridders52. Do you have any links you can direct me to that covers best practice and how to encrypt and manage passwords outside of the database?

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by brose View Post
    Thanks ridders52. Do you have any links you can direct me to that covers best practice and how to encrypt and manage passwords outside of the database?
    I'm afraid not. Suggest you do Google searches - there may also be You Tube videos

    I setup encryption in two of my own databases over 10 years ago and for fairly obvious reasons, can't share my code here.
    This screenshot shows what encryption might look like - the length of the password & encrypted version don't match

    Click image for larger version. 

Name:	Capture.PNG 
Views:	22 
Size:	5.5 KB 
ID:	33573

    However, normally I use passwords stored in Active Directory so I'm not directly responsible for password security
    That's even more important with the new data protection legislation about to be implemented next month
    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

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

Similar Threads

  1. Replies: 4
    Last Post: 03-28-2017, 03:10 PM
  2. Replies: 2
    Last Post: 02-27-2015, 10:03 PM
  3. Replies: 1
    Last Post: 01-13-2014, 02:47 PM
  4. Web Database: Input Mask for Password
    By besuchanko in forum Forms
    Replies: 3
    Last Post: 07-25-2013, 03:28 PM
  5. Replies: 1
    Last Post: 01-21-2013, 02:08 PM

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