Where do I put the code - How To Encrypt Table Data With VBA Code and Custom Encryption Modules in Microsoft Access


	Back to Access Data Encryption Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Where do I put the code

Nathan Shepard

2 years ago

Without broadcasting to every hacker.  I need to know where to put the code.

I have A logon form.  The user must enter User Name and password.  It checked if it been over 60 day old.  The user gets one shot to enter Username and password correctly.  if not the database exits and closes.  All fields stay encypted.
Its only when the user gets to the main menu is the data decypted.

My question is how and where do put the code to decrypt the data.
2nd question is how and where do I put the code to encrypt all fields upon exiting the database.

I am thinking before writing the code in my database.  I should take Richards code.  Add multiple records.   Then put a button close the database and encrypt all fields.
This way I will not miss up my test data in my database.  Yes, Richard, I will backup my database before incorporating this code in my database.

Please give me your thoughts on where to put the code.  Remember I am encrypting all fields.  This way my future customers are protected.  Thank you for responding.

Nathan Shepard OP @Reply

2 years ago

I changed my mind. Taking my fields in each record and ultimately test data file. I created a continuous data form. From there I changed a few lines of code for encrypting my test data. Me being the sole author knows what those changes are. So Hackers can try, but the sky is the limit. Good luck hackers Ultimately, I will also encrypt the table containing user name and password to initially open the database software.

I am sure that there are other Programmers that would love how to intergrate code into their database. That's why I am putting it on the Forum. As I progress with my experiment or testing I will update the results. Further, how I created the subroutine. So Standby for final results.

	Richard Rost @Reply 2 years ago
I would decrypt each record as its loaded and encrypt it again when the user closes the form or moves off the record. I don't normally decrypt continuous form data... but then again, I don't use this to encrypt ALL of the fields, only sensitive ones.

Nathan Shepard OP @Reply

2 years ago

Thank you for responding Richard. Can you suggest some commands that I would use to encrypt all 9 fields and (240 Records of sample data). So, what you saying is in my add screen. That is where the code encryption code would go. I think I answered my own questions. The test data I have will not go with the software. So what I have for test data does not need to be encrypted.
I will start with 30 records and try that. Standby for results.

	Richard Rost @Reply 2 years ago
Decrypt in the Form Load (or Open) event. Encrypt in Form Unload (or Close). The only way you'd have a problem is if someone KILLS the MSACCESS.EXE task (process) or your database exits on an error.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Data Encryption Lessons.

Next Unseen

New Feature: Comment Live View