By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,643 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

Encrypt / Decrypt output text file

P: n/a
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?

May 17 '07 #1
Share this Question
Share on Google+
4 Replies


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

Of course. DoCmd.TransferText 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?
May 18 '07 #2

P: n/a
And do you have any sample code?

May 19 '07 #3

P: n/a
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?
May 20 '07 #4

P: n/a
Well, thanks for your 80%!

May 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.