Results 1 to 7 of 7

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

  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:	19 
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
    44,617
    Table Design View > Input Mask > Password.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #3
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,166
    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 (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment
    nil illegitimi carborundum est

  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:	17 
Size:	99.5 KB 
ID:	33568
    Click image for larger version. 

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

Name:	Capture3.JPG 
Views:	17 
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
    44,617
    Don't use Format property.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  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
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,166
    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:	17 
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 (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment
    nil illegitimi carborundum est

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

Similar Threads

  1. Replies: 4
    Last Post: 03-28-2017, 02:10 PM
  2. Replies: 2
    Last Post: 02-27-2015, 09:03 PM
  3. Replies: 1
    Last Post: 01-13-2014, 01:47 PM
  4. Web Database: Input Mask for Password
    By besuchanko in forum Forms
    Replies: 3
    Last Post: 07-25-2013, 02:28 PM
  5. Replies: 1
    Last Post: 01-21-2013, 01: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
  •  
Tech Forums: Microsoft Office Forums