2

We would like to decrypt data stored in Microsoft Access.

Without getting into too much detail we have a Web Form, written in PHP, that saves Form Data (encrypted) to a MySQL table. MS Access copies that Form Data (via an ODBC link) from MySQL to its own table. I am following this post Decrypt PHP encrypted string in C# thinking that VBA and VB.net should be close enough that I can work out the errors. But I don't see System.Security.Cryptography listed in 'Access database Object Library'. Is it possible to add System.Security.Cryptography to MS Access and if so how? If MS Access doesn't support adding System.Security.Cryptography, do you have any ideas on how to decrypt data within MS Access that was encrypted in PHP?

Thanks

Community
  • 1
  • 1
Chris
  • 380
  • 5
  • 10

1 Answers1

3

You could create a C#/VB.Net library that simply encrypts/decrypts data, expose it as COM and call it from Access. It's very simple to do and I've successfully done this with various projecs. Rich Newman has a very good article on how to do this here.

Eddie Paz
  • 2,219
  • 16
  • 11
  • In case this might help others I started with Rich Newman's article that Eddie Paz mentioned and I used/modified the script found [here](http://www.expertcore.org/viewtopic.php?f=67&t=2576) which uses PHP and VB.NET. – Chris Feb 22 '12 at 13:11