Encrypt / Decrypt output text file

[Max Vit]

Here is my problem: I have an application built in Access that outputs
sensitive data to a text file.
I would like to encrypt this data *whilst* the file is being
outputted.
The encryption I was using before (very weak) was to encrypt the file
*after* the output had been completed but if for some reason the
output did halt before being completed; then the text file was able to
be read.
....and the encryption needs to be able to be decrypted too :-)
I have seen few postings on encryption but I don't seem to find the
right way to do this.
Any ideas?

[Tom van Stiphout]

On 17 May 2007 08:27:45 -0700, Max Vit <mv**@safe-mail.netwrote:

Of course. DoCmd.TransferT ext is one good way to export data to text.
It can take a queryname as one of its parameters.
Your query looks like this:
select field1, field2, .... Encrypt(fieldN)
from sometable

The public function Encrypt would be called by this query, passing in
the value of fieldN, which you can then encrypt.

I'm sure you will have no problem figuring out how to reverse the
procedure and decrypt.

-Tom.

>Here is my problem: I have an application built in Access that outputs
sensitive data to a text file.
I would like to encrypt this data *whilst* the file is being
outputted.
The encryption I was using before (very weak) was to encrypt the file
*after* the output had been completed but if for some reason the
output did halt before being completed; then the text file was able to
be read.
...and the encryption needs to be able to be decrypted too :-)
I have seen few postings on encryption but I don't seem to find the
right way to do this.
Any ideas?

[Max Vit]

And do you have any sample code?

[Tom van Stiphout]

On 19 May 2007 06:52:10 -0700, Max Vit <mv**@safe-mail.netwrote:

Sorry, I gave you 80% of what you need. Most Access powerusers or
developers will run with that. Complete customized solutions are not
the purpose of this forum.

-Tom.

>And do you have any sample code?

[Max Vit]

Well, thanks for your 80%!