Encrypt / Decrypt output text file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Max Vit
    #1

    Encrypt / Decrypt output text file

    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?

    Tags: encryptdecrypt +vba
    • Tom van Stiphout
      #2
      Re: Encrypt / Decrypt output text file

      On 17 May 2007 08:27:45 -0700, Max Vit <mvit@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?

        Comment

        • Max Vit
          #3
          Re: Encrypt / Decrypt output text file

          And do you have any sample code?

            Comment

            • Tom van Stiphout
              #4
              Re: Encrypt / Decrypt output text file

              On 19 May 2007 06:52:10 -0700, Max Vit <mvit@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?

                Comment

                • Max Vit
                  #5
                  Re: Encrypt / Decrypt output text file

                  Well, thanks for your 80%!

                    Comment

                    Previous template Next
                    Working...