sending password-protected data/reports on emails with Access 2000

[David Gartrell]

Hi there,

I wonder if someone out there could help me out please. I have several
database that are written & run in Access 2000. These database all send off
emails once a week that contain database generated data/reports in the form
of either RTF files or XLS files. The problem I have is that I'm trying to
find a way of password protecting these at the point when Access sends
them - so far without any luck!

Would anyone have any suggestions at all as to how I could do this please?
The whole procedure is done automatically in the middle of the night by
using Windows Task Scheduler to run an Access macro, so anything you suggest
would have to be free of human interevention i'm afraid.

Many thanks in advance for any help you can give.

David

p.s. if you feel I've posted this to the wrong NG please could you suggest a
better group to post to - many thanks

 

[bhicks11 via AccessMonster.com]

Hi David,

How about zipping the report with a password. A product like WINZIP has a
command line add on so you can automate it through code.

Bonnie
http://www.dataplus-svc.com

 

[Tony Toews [MVP]]

I wonder if someone out there could help me out please. I have several
database that are written & run in Access 2000. These database all send off
emails once a week that contain database generated data/reports in the form
of either RTF files or XLS files. The problem I have is that I'm trying to
find a way of password protecting these at the point when Access sends
them - so far without any luck!

You probably could create XLS with Excel automation using VBA code. I
don't know if RTF files can even contain passwords. See the Access
web pages at www.mvps.org/access for some sample code to get you
started. It won't have the password stuff on it but using
intellisense and Excel macro help you should be able to figure that
out.

As Bonny suggest zipping files could also work although I'd use the
free, open source zip32 dlls as Compression DLLs, OCXs, etc web page
at
http://www.granite.ab.ca/access/compression.htm

Also it is possible Stephen Lebans may add passwords to his PDF So
check his website frequently if that's of interest.
A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required. http://www.lebans.com/reporttopdf.htm

p.s. if you feel I've posted this to the wrong NG please could you suggest a
better group to post to - many thanks

This one is just fine.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[bhicks11 via AccessMonster.com]

Bummer - I paid for WINZIP. Thanks, I'll use the free next time.

Bonnie

 

[Tony Toews [MVP]]

Bummer - I paid for WINZIP. Thanks, I'll use the free next time.

Paying for Winzip is a good thing if you're using it yourself.
<smile> As I have.

But using the free, open source dlls means you can distribute a
solution to your users legally and simply.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[bhicks11 via AccessMonster.com]

I'm glad to know of the source. I haven't distributed a zip program with an
app since PKZIP for DOS but can't use that any more because of the 8.3 naming
limit.

Thanks,

Bonnie
http://www.dataplus-svc.com

 

[Tony Toews [MVP]]

I'm glad to know of the source. I haven't distributed a zip program with an
app since PKZIP for DOS but can't use that any more because of the 8.3 naming
limit.

As I recall even PKZip for DOS could have been licensed. Not that
there were nag screens.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[bhicks11 via AccessMonster.com]

I had this one so long it was on a contribution basis!