Solved

Use System.Security.Cryptography in MS Access

Posted on 2009-07-06
4
1,396 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

738 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