Automate WinPt (GnuPG) from Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there,
I am hoping to create text files from Access, then use WinPT to encrypt
them, and load them on to an FTP site. I'd like to do all of this from code,
so the user just has to click a button and the file is uploaded.

Similarly, I'd like to check the same FTP site for files, download and
decrypt them, then import into Access. Can I control WinPT from Access?

Any help is appreciated...I'm new to PGP!
Thank you!
Gretchen
 
I'm new to PGP, GnuPG and WinPT all three. But in general, when you want
to program a Gnu utility you should ignore the GUI front end (when there
is one) and use the utility's own command-line interface (typically
you'd pass command lines using the VBA Shell() function.) The main
exception is if the front end exposes an OLE object model.
 
Thank you, John. I found that gnupg.org has lots of info on commands, so
that with your advice will help get me going.
 
Good luck. One thing you may need is a ShellAndWait() VBA function. The
standard Shell() launches your command and then lets Access move on to
the next line of VBA code; but sometimes you may need to wait until
GnuPG has finished the task you sent it before you can safely let your
code take its next step. If so, get a ShellAndWait. There's one
somewhere in www.mvps.org/access, and others here and there on the web.
 
Back
Top