Is there a VBA encryption functionality in Access, built-in or otherwise? E.g., something like:
(I would need a symmetric algorithm)Code:MyEString = EnCipher(MyString,MyCipherKey)
Is there a VBA encryption functionality in Access, built-in or otherwise? E.g., something like:
(I would need a symmetric algorithm)Code:MyEString = EnCipher(MyString,MyCipherKey)
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
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
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
I wouldn't know, I'm receiving notifications!Is the Forum having problems?
I sent a note to the Forum webmaster this morning, 5/8.
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
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 ,... 😉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