• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1533
  • Last Modified:

Use System.Security.Cryptography in MS Access

I need to encrypt/decrypt string data.  I have read and researched a lot about how to use System.Security.Cryptography.  Evidently I am missing something fundamental.  I need a function that is easy to use that takes a string, encrypts it and returns the encrypted string (and vise versa).

All the examples use another platform other than MS Access 2007.  This is my only platform.  First, is there a reference I need to add to my VBA project?
Second, can I have an example of how to use it?

  • 2
  • 2
1 Solution
System.Security.Cryptography is a .net namespace, so you cannot use it directly in access
you can build a .net com-visible dll that will encapsulate the functions you need (like Cypher and Decypher or something)
and then register that dll on the target machine, and then add a reference to it in references section in access, and only then you would be able to use it.
quite a long way to go, but if you need it, then good luck
if you need help along the way, though, feel free to ask
AviationAceSole-ProprietorAuthor Commented:
Bummer.  There is no way I can implement that in my case.  You have any other suggestions for writing an encryption function?
AviationAceSole-ProprietorAuthor Commented:
I am looking at what's on www.cryptovb.com.  I downloaded the files there and I noticed it is using advapi32.dll a lot.
Can you give a me an example of how to use it?  I just need to input a string and have it encrypted, and then be able to do the reverse.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now