John W. Colby
jcolby at ColbyConsulting.com
Wed Apr 2 16:58:15 CST 2003
Secure how? If it is personal information, it should be encrypted, or sent over a VPN. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bucher, Dave Sent: Wednesday, April 02, 2003 5:27 PM To: 'accessd at databaseadvisors.com' Subject: [AccessD] Securing an Excel file programmatically from Access Hi Everyone- Great praise to all you gurus who I've garnered much from in the past. Using Access97 and Excel97 ... I'm using DoCmd.OutputTo in Access to output reports in .xls format and programatically send (twice a month) to a client outside our network. The problem is, our network is secure and client's isn't, so the folks enforcing the big bad fed privacy laws don't want to let us send things with the push of a button! Talk about trying to keep good gov't. down! Does anyone have code to secure the newly (OutputTo) created Excel worksheet after it has been created prior to sending? Thanks much! Dave Bucher Information Technology Specialist Children's Research, Planning and Evaluation "Launch your boat, oh blessed youth, and flee at full speed from every form of culture."--Epicurus _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2528 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030402/43b80f9c/attachment-0001.bin>