Solved

Use System.Security.Cryptography in MS Access

Posted on 2009-07-06
4
1,357 Views
Last Modified: 2013-11-27
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?

Thanks.
0
Comment
Question by:AviationAce
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:ErezMor
ID: 24786834
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
0
 

Author Comment

by:AviationAce
ID: 24787287
Bummer.  There is no way I can implement that in my case.  You have any other suggestions for writing an encryption function?
0
 
LVL 12

Accepted Solution

by:
ErezMor earned 500 total points
ID: 24787349
0
 

Author Comment

by:AviationAce
ID: 24788918
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.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question