[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Use System.Security.Cryptography in MS Access

Posted on 2009-07-06
4
Medium Priority
?
1,477 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 1500 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The recent Petya-like ransomware attack served a big blow to hundreds of banks, corporations and government offices The Acronis blog takes a closer look at this damaging worm to see what’s behind it – and offers up tips on how you can safeguard your…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

650 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