[AccessD] Securing an Excel file programmatically from Access

Dave,

We also cannot send any data covered by any of the privacy laws/regs to
outsiders unless they sign the same privacy statement that we have to
sign.  Once your outside client has signed the required paperwork and
put in place the required privacy restrictions, your security people
should have no objections to you pushing a button and sending the data.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Bucher, Dave [mailto:Dave.Bucher at state.mn.us] 
Sent: Wednesday 2003 Apr 02 16:27
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