AES Encrypting a Microsoft Access Field Via VBA

Posted by Jason on Stack Overflow See other posts from Stack Overflow or by Jason
Published on 2010-06-14T15:29:22Z Indexed on 2010/06/14 15:32 UTC
Read the original article Hit count: 340

Filed under:

vba

|

aes

|

access-vba

I need to create a Microsoft Access database, but have a need, in one of my tables, for a single field to be strongly encrypted.

Since AES requires both a key and an initialization vector, I've decided to solve this problem by requiring a password to access the database (as the key), and a field in the table to hold a SHA1 hash of the plaintext of the encrypted field.

Does anyone know where I can find VBA-compatible code to actually do the encryption?

© Stack Overflow or respective owner

Related posts about vba

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

as seen on Developper.com - Search for 'Developper.com'
Bonjour, Ci-dessous, le lien vers un nouveau tutoriel : « Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox » Le but de ce tutoriel est : De présenter une bonne approche de la résolution d'un problème simple en VBA. D'expliciter en… >>> More
Run VBA macro when condition is met

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm creating a spreadsheet to train my numerical skills. Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying. Is there a way that I can execute a… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Excel 2007 VBA macros don't work in Parallels

as seen on Super User - Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet… >>> More

Related posts about aes

Optimizing AES modes on Solaris for Intel Westmere

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Optimizing AES modes on Solaris for Intel Westmere Review AES is a strong method of symmetric (secret-key) encryption. It is a U.S. FIPS-approved cryptographic algorithm (FIPS 197) that operates on 16-byte blocks. AES has been available since 2001 and is widely used. However, AES by… >>> More
Using AesCryptoServiceProvider in VB.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
My problem is actually a bit more complicated than just how to use AES in VB.NET, since what I'm really trying to do is use AES in VB.NET from within a Java application across JACOB. But for now, what I need to focus on is the AES implementation itself. Here's my encryption code Public Function… >>> More
Encrypted AES key too large to Decrypt with RSA (Java)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am trying to make a program that Encrypts data using AES, then encrypts the AES key with RSA, and then decrypt. However, once i encrypt the AES key it comes out to 128 bytes. RSA will only allow me to decrypt 117 bytes or less, so when i go to decrypt the AES key it throws an error. Relavent… >>> More
Solaris X86 AESNI OpenSSL Engine

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Solaris X86 AESNI OpenSSL Engine Cryptography is a major component of secure e-commerce. Since cryptography is compute intensive and adds a significant load to applications, such as SSL web servers (https), crypto performance is an important factor. Providing accelerated crypto hardware greatly… >>> More
Solaris X86 AESNI OpenSSL Engine

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Solaris X86 AESNI OpenSSL Engine Cryptography is a major component of secure e-commerce. Since cryptography is compute intensive and adds a significant load to applications, such as SSL web servers (https), crypto performance is an important factor. Providing accelerated crypto hardware greatly… >>> More