Results 1 to 10 of 10
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Encryption

    Is there a VBA encryption functionality in Access, built-in or otherwise? E.g., something like:



    Code:
    MyEString = EnCipher(MyString,MyCipherKey)
    (I would need a symmetric algorithm)

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    short answer is no - but there are plenty of vba examples out there

    here is one https://gist.github.com/JonTheNiceGu...94da0a56841202

    I believe there was a library but don't know what it was called and believe it is 32bit only and no longer supported. These days you would use System.Security.Cryptography

    here is an example link https://docs.microsoft.com/en-us/dot...ypting-strings

  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
    Have a look at the RC4 encryption that I use to encrypt passwords in this example app: PasswordLogin.
    Not sure what you mean by 'symmetric' but RC4 is reversible if you know the cipher
    That makes it easier to work with but less secure than one-way ciphers
    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
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Thanks Colin & Ajax.
    At the moment, I'm trying to determine WHY I DIDN'T receive an email telling me that there had been a reply to my post. It's now several days later and had I not logged onto the forum to have a peek I would not have discovered that the two of you had offered a suggestion as to where there might be a method I could consider. Is the Forum having problems?
    Bill

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Is the Forum having problems?
    I wouldn't know, I'm receiving notifications!

  6. #6
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    I sent a note to the Forum webmaster this morning, 5/8.

  7. #7
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Problem solved. It seems that after all these years that either "gmail" or my email client thinks emails coming to me from "Microsoft Access Forums" is "Spam".

    Thanks again Colin & Ajax for your suggestions.
    Bill

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    OK so you've solved your email notification issue but that wasn't the original point of this thread 😉
    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

  9. #9
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Hi Colin,
    Sorry to not have offered more than a thanks to you and Ajax. There really isn't any function exactly like I offered as a pseudo example in my OP. I've been writing hashing code for years but really wanted to be out of the business of doing so and would have welcomed such functionality in VBA if it existed. Alas, I've just picked up some of my old private code, shrugged my shoulders and moved on. Twiddling bits in VBA is not a happy experience

  10. #10
    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 GraeagleBill View Post
    Hi Colin,
    Sorry to not have offered more than a thanks to you and Ajax. There really isn't any function exactly like I offered as a pseudo example in my OP. I've been writing hashing code for years but really wanted to be out of the business of doing so and would have welcomed such functionality in VBA if it existed. Alas, I've just picked up some of my old private code, shrugged my shoulders and moved on. Twiddling bits in VBA is not a happy experience
    It could be said that any programming in Access is a bit like twiddling with your bits ,... 😉
    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. SQL Server Data Encryption
    By jerem in forum SQL Server
    Replies: 1
    Last Post: 05-02-2016, 11:11 PM
  2. Split DB with BE encryption
    By mpaulbattle in forum Access
    Replies: 6
    Last Post: 05-21-2015, 12:48 PM
  3. Generate encryption file
    By JanJau in forum Security
    Replies: 3
    Last Post: 02-25-2015, 11:41 AM
  4. Password field encryption
    By bakkouz in forum Database Design
    Replies: 3
    Last Post: 10-10-2011, 07:15 AM
  5. OLE Db Encryption error
    By lkmaurik in forum Programming
    Replies: 1
    Last Post: 05-23-2011, 04:01 AM

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