Encroypt the final date

[sbaud2003]

Hi Everyone, hope all of you are safe.
In my data base final output is converted into a text file
Now I want to encrypt the data.
Is there any way to do it.
Thanks

 

[theDBguy]

Hi. There are lots of encryption samples available. What did you have in mind?

Edit: Here's one example:
General VBA/VB6 - Encryption and Compression Module: Encrypt and decrypt a Unicode or ASCII string using XOR password encryption in VBA and VB6 (fmsinc.com)

Edit: Here's another one:
RC4 Encryption Algorithm for VBA and VBScript - Microsoft Access / VBA (bytes.com)

 

[sbaud2003]

Hi. There are lots of encryption samples available. What did you have in mind?

Edit: Here's one example:
General VBA/VB6 - Encryption and Compression Module: Encrypt and decrypt a Unicode or ASCII string using XOR password encryption in VBA and VB6 (fmsinc.com)

Edit: Here's another one:
RC4 Encryption Algorithm for VBA and VBScript - Microsoft Access / VBA (bytes.com)

Thanks I am little confused...
the text file created at the end is saved in a folder Named "ADVICE" say in the name TFILE1.TXT, TFILE2.TXT etc.
now I want to encrypt the file the samples are attached. Encription has been done using Hekapad.

 

[theDBguy]

Okay, I see what you mean. You want to encrypt the entire text file after you have exported the data. The only way I could think of at the moment is to read the text file's content into memory and then encrypt it, then write the encrypted data back into the text file.

I was thinking it would be simpler to encrypt the data from the database as you export them into the text file, eliminating the extra step of reading the unencrypted text file to encrypt it.

 

[sbaud2003]

Okay, I see what you mean. You want to encrypt the entire text file after you have exported the data. The only way I could think of at the moment is to read the text file's content into memory and then encrypt it, then write the encrypted data back into the text file.

I was thinking it would be simpler to encrypt the data from the database as you export them into the text file, eliminating the extra step of reading the unencrypted text file to encrypt it.

Thanks for you prompt reply. Can you help me in this.

 

[theDBguy]

Thanks for you prompt reply. Can you help me in this.

Hi. I can help you along your path by helping you fix any problems you encounter. Try to build something, based on the links I posted earlier, and let us know what happens.