Password protect Snapshot files?

J

John G

Is there any way to have a snapshot file password protected like pdf files
can be? I'm using the following code to save reports as snapshots.

DoCmd.OutputTo acOutputReport, strDocName, acFormatSNP, sPath & _
strTitle & ".SNP", False

This works good for saving reports in snapshot format but I was wondering if
it's possible to include a password.

Thanks for your help.

John G
 
C

Chris O'C via AccessMonster.com

You can't put a password on a snapshot file. If you have any app in Office
2007 there's a free add in from Microsoft to create pdf files. You could use
that to export your reports to pdf. I don't know if it adds passwords to the
file.

Of if you have a tool to add a password to a pdf, use Access MVP Stephen
Lebans free A2000ReportToPDF utility to convert a report to a pdf file. (I
don't think his tool provides a way to password protect the pdf, but I could
be wrong.)

http://www.lebans.com/reporttopdf.htm

Chris
Microsoft MVP
 
J

John G

Thanks for your quick reply.
I also use Stephen Lebans free A2000ReportToPDF utility which can create a
secure (password protected) pdf file. However, Snapshot files are about
1/10th the size of pdf files and most of the people sending these reports are
in the rural area and do not have high speed internet. Therefore it would be
much easier for them to send SNP files instead of PDF files.
Thnaks again for your time and information.
 
C

Chris O'C via AccessMonster.com

Put the snapshot file in a zip file and password protect that before sending
over the internet.

Chris
Microsoft MVP


John said:
Thanks for your quick reply.
I also use Stephen Lebans free A2000ReportToPDF utility which can create a
secure (password protected) pdf file. However, Snapshot files are about
1/10th the size of pdf files and most of the people sending these reports are
in the rural area and do not have high speed internet. Therefore it would be
much easier for them to send SNP files instead of PDF files.
Thnaks again for your time and information.
You can't put a password on a snapshot file. If you have any app in Office
2007 there's a free add in from Microsoft to create pdf files. You could use
[quoted text clipped - 19 lines]
 
S

Stephen Lebans

If you do not embed Fonts and pass a high value for the Compression param
then my ConvertReportToPDF function will produce file similiar in size to
Snapshot files.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top